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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
