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.
Incremental Extraction Using a Change Identifier Value If your source tables contain a change identifier value (such as a last modified datetime), or you are able to make small changes to your source tables to allow this, then the process in SSIS will involve three steps: 1  Targeting the changed records by making the source query dynamic.