Query On DTS package

[madankarmukta]

Hi All,

I have a batch job. I am trying to run this job with DOMAIN1\USER1 as user from MACHINE1.

The batch file triggers to the DTS package internally. If I tried to open another text file through this package.. with what userId will it try to open the text file ?

The text file is placed at the location \\SomeShredLoca tion\Folder1\my TextFile.txt

Looking for the valuable inputs.

Thanks!

[shihonage]

the user is based on whoever is running the package

usually packages are run using sql agent. the sql agent service owner (or whatever user that runs the package) will carry the permissions.