Run dtsx file as different user
Posted on 2013-11-08
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=SQLNCLI11;Integrated Security=SSPI;Auto Translate=false;" />
Am I on the right track with this? How do I include the new user's creds? Thanks.