CONT'D it is ONLY the scheduled package that is failing, the DTS package executes perfectly when I do a execute DTS package....FYI
>|> -----Original Message----- >|> From: Bradford T Comer [mailto:[EMAIL PROTECTED] >|> Sent: Thursday, July 17, 2003 1:12 PM >|> To: [EMAIL PROTECTED] >|> Subject: RE: DTS / Schedule assistance >|> >|> >|> Ok I managed to get it to find the right file by recreating the >|> DTS package from scratch, must have kept some test >|> settings....thus the path the DESKTOP. >|> >|> HOWEVER now I am getting a ACCESS DENIED to the file I am >|> trying to write too, I made sure to use WINDOW AUTHENTICATION >|> for both SOURCE and DESTINATION....any suggestions? >|> >|> Thanks >|> Brad >|> >|> >|> -----Original Message----- >|> >|> From: Bradford T Comer [mailto:[EMAIL PROTECTED] >|> >|> Sent: Thursday, July 17, 2003 12:52 PM >|> >|> To: [EMAIL PROTECTED] >|> >|> Subject: DTS / Schedule assistance >|> >|> >|> >|> >|> >|> Good Day All, >|> >|> >|> >|> I have a dilemma for which I need some advice. >|> >|> >|> >|> I have a MSSQL 2k machine that is my websites DB server, I then >|> >|> have a Win2k Server for the actual webserver. >|> >|> >|> >|> My client requested a data dump to text file and have it >|> >|> accessible via FTP. FTP does not run on the DB server, only the >|> >|> web server. >|> >|> >|> >|> SO I created a DTS package that exports the data to a text >|> >|> file, no sweat works great, I used UNC paths to have it write >|> >|> the dump text file to the web server. >|> >|> >|> >|> When I schedule and then attempt to run the scheduled package, >|> >|> I get a error; it is stating that the file can not be found, >|> >|> but it is looking for the file on the DESKTOP of the DB >|> >|> server....WHAT THE HELL did i do wrong? Any ideas? >|> >|> >|> >|> Thanks In Advance! >|> >|> Brad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
