SSIS Package Foreach Loop with File Connection. This package gives you an idea to get file details and variable mapping between Foreach Loop Container and any inner task contains in loop (here inner task is Script Task). Step1 : Drag Foreach Loop and script task from SSIS Toolbox. Step2 : Create one variable with name [...]