Load Multiple CSV file using Foreach loop container

 In the previous post we saw that how to load the Multiple CSV files with same structure into the database.

Read Here : Multi flat file connection manager in SSIS

https://bageshkumarbagi-msbi.blogspot.com/2021/12/multi-flat-file-connection-manager-in.html

In this post we will see how to load the multiple CSV files using Foreach loop container.

Taking the Foreach loop and doing the configuration.

  

Storing the file full path into the variable and this value we are suing in the dynamically in the flat file connection manager.

  

Taking Data flow Task in the Foreach loop container and taking source as flat file and destination as OLEDB destination.

  

Flat file connection manager we need to set the expression.

  

We need to set the delay validation property as True for the Foreach loop container and Data Flow Task.

Read More about: Delay validation property in SSIS

https://bageshkumarbagi-msbi.blogspot.com/2016/09/delay-validation-properties-in-ssis.html

 No our package is ready to run.

 See the records in the Stage table.  

Running this package.

  

Package executed successfully

See the execution progress.

  

See the records in the stage table.

  

Data loaded successfully.