Displaying posts tagged with

“ForEachloop Container”

SSIS Package with Dynamic ADO Connection

SSIS Package with Dynamic ADO Connection. I have created a package that collects database information from different instances all over the network and stored in one central database table. For this, I have collected Server Name, Database Name, Logical File Name, Physical File Name and File Size in MB. I have stored all instance info [...]

SSIS Package Foreach Loop with File Connection

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 [...]