Top "Foreach-loop-container" questions

Questions about the SQL Server Integration Services (SSIS) "foreach loop container"

How to store 'fully qualified' and 'name only' file name in SSIS variable

I have an SSIS package that has a Foreach Loop container loading all .txt files in a static folder. I'm …

Read More
sql-server variables ssis etl foreach-loop-container
How do I programmatically get the list of MS Access tables within an SSIS package?

I have inherited a terribly written MS Access database that I need to import into SQL. The Access database has …

Read More
ms-access ssis foreach-loop-container
How to fix source is empty error in XML source while using Foreach loop container in SSIS 2012?

I have an issue with a very simple task in SSIS 2012. I have a for-each container that runs in FOR-EACH-FILE …

Read More
variables ssis mapping foreach-loop-container