When you execute the DTS yourself, it uses your logon as the security
context. When you schedule the package, it will use the context of the
job as registered with the SQL Server Agent. You usually must use a
domain account, because otherwise you will have to provide a way to write
the file from the Guest account.
"Bradford T Comer" <[EMAIL PROTECTED]>
07/17/2003 02:12 PM
Please respond to sql
To: SQL <[EMAIL PROTECTED]>
cc:
Subject: RE: DTS / Schedule assistance
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
