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.
Select the Settings tab. Enter a Name for the connection string. Refer to this name when accessing the connection string in code. Set the Type to (Connection string) . Leave the Scope set to Application. Type your connection string into the Value field. -or-. Click the ellipses (...