Accessing files on another server using DTS. (dtsrun vs. EM) 1

[KevinFSI]

I did a search, but didn't really see anything about this.

I have a DTS package which exports a text file to a folder on another machine. If I go to Enterprise Manager and execute the DTS package manually, it works fine. If I execute a dtsrun command from QA using xp_cmdshell, I get a failure (bad username or password.)

So, I created a test DTS package which simply does a SELECT on current datetime, and used dtsrun to execute it, and it works fine. When I try to output that data to a file on the server I'm having problems with, I get the error.

I know the problem is with my permissions on the directory on that server, but what I don't know is, who do I give "write" permissions to??? What's the difference between the user invoking the DTS package within EM, and the one calling it via dtsrun.

Am I making sense?

Note - This worked for 18 months and quit working at about 4:00 PM last Friday.

Kevin
slanek@ssd.fsi.com

"Life is what happens to you while you're busy making other plans."
- John Lennon

 

[mrdenny]

When you run a package from EM the account that you are logged into Windows with is the account that runs the package.

When you run the package from a job, the account that runs the package is the account that the SQL Server Agent is running as.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[KevinFSI]

That's exactly the answer I was looking for. Thanks!

Kevin
slanek@ssd.fsi.com

"Life is what happens to you while you're busy making other plans."
- John Lennon