In SSIS there are system and user variables. These are different than script variables. See [http://technet.microsoft.com/en-us/library/ms141085.aspx] to get you started. Yes user variables can do exactly what you want. You can find a good beginners tutorial on SSIS and variables here: https://www.sqlservercentral.com/articles/batch-etl-of-multiple-data-files-using-an-ssis-foreach-loop-container-1 It also goes through other things, but what you're looking for is there.
17 People are following this question.