Ssis loop through files variable

CreationTime ;. GetFileName file ;. ExecuteNonQuery ;. Close ;. Success ;. Author Recent Posts. Sifiso W. He currently works for Sambe Consulting as a Principal Consultant. View all posts by Sifiso W. Latest posts by Sifiso W. Add the Foreach Loop Container and double-click it to open the properties dialog box. Apply the following settings:. Add the Data Flow task inside the Foreach Loop container by completing the following steps:. Place the File System Task to move the processed file to the archive folder.

Specify the properties as displayed below:. Connect all tasks and run the package. If everything is configured correctly, the files should load into the staging table and then move to the Archived folder.

With Task Factory, you can connect to nearly any data source with ease. To learn more about how Task Factory can help you, see the Task Factory product page. Melissa has over a decade of experience with SQL Server through software performance and scalability testing, analysis and research projects, application development, and technical support.

Products Overview. Database Monitoring. Free Tools. Set path based on your rule using an expression. What do you suggest? The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums.