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
EXPRESSIONS
EXPRESSIONS
XSD location hardcoded in XML source
Case The path of the XSD file in the XML Source component is hardcoded, but the path on my production environment is different than my development en…
Add Expression Builder to custom task
Case I have created a custom task, but I would like to add the built-in Expression Builder to it. How do you do that? Solution It is possible, but it…
Continue Loop after error - Part II
Case I used the propagate variable trick to continue a loop on error. That works within the package, but the parent package calling the package with…
Custom SSIS Component: Multiple Expressions Task
To change the value of a variable during runtime you need an expression or a Script Task . The expression isn't very flexible and the Script Tas…
Often used SSIS expressions
Here is a list of often used SSIS expression which I will expand regularly. You can leave your own handy expression in the comments. Or let me know i…