Foreach loop with *.xls wildcard also returns *.xlsx files
Case I have a Foreach Loop Container with a file enumerator. The wildcard is *.xls, but it also returns *.xlsx files. How do I prevent that? Loop t…
Search Suggest
SSIS 2005
SSIS 2005
Execute multiple child packages in parallel with loop
Case I used a foreach loop to execute all my staging packages, but my server isn't using all resources. Is there a way to execute multiple child…
Performance Best Practice: Flat File (Fast) Parse
Here are some tips to speed up the reading of flat files within the SSIS data flow. They are especially handy for importing large flat files (or when…
Performance Best Practice: more rows per buffer
SSIS uses buffers to transport a set of rows through the data flow task. In general the less buffers you need to transport all rows from the source t…
Performance Best Practice: Network Packet Size
Network If your SSIS package gets its data from a SQL Server database located on an other machine, then the data of your query will go from the SQL …
Value of variable during runtime
Case I want to know the value of a variable during runtime of an SSIS package. Value of variable between two tasks Solution You can either use a brea…
Master Child packages - Part 2: SQL Server based
Case An often seen solution is a master package calling a couple of child packages with the Execute Package Task. This works fine for a couple of pac…