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.
Set package properties in the Properties window. In SQL Server Data Tools (SSDT), open the Integration Services project that contains the package you want to configure. In Solution Explorer, double-click the package to open it in SSIS Designer, or right-click and select View Designer. Click the Control Flow tab and then do one of the following: Right-click anywhere in the background of the control flow design surface, and then click Properties. On the View menu, click Properties Window. Edit the package properties in the Properties window. On the File menu, click Save Selected Items to save the updated package.