A carbocation (/ËkÉËrboÊËkÃ¦taÉªÉn/) is an ion with a positively charged carbon atom.
You can run your package using DTEXEC, and change your connection by passing in a /CONNECTION parameter. Probably save it as a batch so next time you don't need to type the whole thing and just change the datasource as required. You can use the SSIS XML package configuration file. Here is a walk through.
1 Connect to the new server SSIS through SSMS. 2  Open Stored Packages and right click MSDB. 3  Select Import Package..., set the Server to the source instance (MSDB where the package resides). 4  Click button for Package path: and select the package from the list.5  Set the Protection level if applicable or leave the default.o the following: 1  Connect to the new server SSIS through SSMS. 2  Open Stored Packages and right click MSDB. 3  Select Import Package..., set the Server to the source instance (MSDB where the package resides).