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
