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.
How do I use a column separated filed within in clause
How can we pass hints to the SQL processor?
What is a co-related sub-query and how it is different from nested queries ?
How a DBA can perform Database maintainance activities with restricted access to DATA?
Can someone help me with this database question? I have attached all the files below.