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.
Dynamic flat file connection string in SSIS. 1  The normal way to handle this is to use a foreach loop that goes through all the files in the folder. 2  Then, if it is the file you want, you set your connection string to use that filename, otherwise, loop to the next file.