By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,415 Members | 1,568 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,415 IT Pros & Developers. It's quick & easy.

Query On DTS package

P: 293
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 \\SomeShredLocation\Folder1\myTextFile.txt

Looking for the valuable inputs.

Jan 5 '10 #1
Share this Question
Share on Google+
1 Reply

P: 1
usually packages are run using sql agent. the sql agent service owner (or whatever user that runs the package) will carry the permissions.
Jan 5 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.