Lets configure File connection from variable for SSIS - Foreach Loop Container.
What we need to do is, we need to process each file from folder, so we need to assign value from variable to File connection, so SSIS Task will read that file and process that file.
To assign FileConnection dynamicaly we need to do following.
1. Right click on File Connection, click Properties.
2. Set DelayValidation = "False", as we need to assign connection dynamically.
3. Click on "Expression", and enter variable name, which we used in SSIS - Foreach Loop Container.
It will assign connection from variable and process that file.
Let me know if you have any question for the same.
Posted by Tejas Shah on November 22, 2017
Posted by Tejas Shah on November 11, 2017
Posted by Tejas Shah on August 12, 2015
Posted by Tejas Shah on June 26, 2015
Posted by Tejas Shah on April 20, 2015