thedeal56
asked on
Run dtsx file as different user
I've created some dtsx files, but now another user needs to run them. When the other user tries to run the file, they get errors. I'm assuming I need to alter the connection string to include their credentials, but I am not sure how. Here is the connection string that is currently in the file:
DTS:ConnectionString="Data Source=(local);Initial Catalog=MWSDGO;Provider=SQ LNCLI11;In tegrated Security=SSPI;Auto Translate=false;" />
Am I on the right track with this? How do I include the new user's creds? Thanks.
DTS:ConnectionString="Data
Am I on the right track with this? How do I include the new user's creds? Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER