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.
You can make use of System.IO.FileInfo to get the file size from within SSIS Script Task. Following example shows how this can be achieved. The example was created in SSIS 2008 R2. Step-by-step process: On the SSIS package's connection create an OLE DB connection to connect to the SQL Server as shown in screenshot # 1.