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.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…