May 11, 2006 at 6:58 am
I created a DTS package. It was a simple one - transfer data from a table to a text file. I exected the package and it ran fine.
But when I put it in a job to run, it seemed to run fine but did not create the text file. I just don't understand why?
In the job
EXEC master..xp_cmdshell 'DTSRun /S"Server" /U"user" /P"password" /N"DTSPackage" /W "0"'
Can anyone help me?
Thanks.
May 11, 2006 at 8:18 am
Is this a remote server? When you "executed the package" did you do so from your machine or from the server?
Also, check the file path.
May 11, 2006 at 8:48 am
The package will execute in the security context of the login designated for SQL Server Agent. Make sure that login has permission to create the text file.
Greg
Greg
May 12, 2006 at 1:24 pm
Check the location of the text file. If you used drive letters in the file name, the file was created from the server's perspective of where the drive letter is mapped, rather than your local machine's perspective.
One way to troubleshoot this issue is to log onto the server either directly or remotely and attempt to execute the package.
Good Luck!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply