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.
SSIS Expression for Variables. A variable value can be derived based on the expression. In the below example, the variable ParentFolder holds the value of the root folder for all data files. Another variable ProductFileName has been defined to have the absolute value of the file name.