Read content of Object variable Case I am filling an Object variable with an Execute SQL Task and I want to use it in a Foreach Loop Container (Foreach ADO Enumerator), but the Fore…
Executing a PowerShell script in an SSIS package Case I want to execute a PowerShell Script within an SSIS package, but there is no PowerShell task. How do I do that in SSIS? Solution There are 3 po…
Azure File System Task for SSIS Case There is an upload and download task in the SSIS Azure Pack, but how can I delete a storage container in my Azure strorage account that was crea…
Reading sensitive parameters in a script Case I have a sensitive parameter in my package with a password in it. I want to use it in a Script Task, but when I try that it throws an error: Exc…
Coming this year... Extending SSIS with .NET Scripting It's not ready yet, but I'm proud to announce the first SSIS book by me and fellow MVP Régis Baccaro ( B | T ). Extending SSIS with .NET Scr…
SSIS 2012 Execute Package Task: External Reference does not work with SSISDB Case I have two SSIS projects (both project deployment) and I within project 'A' I want to execute a package from project 'B' with th…
Retry a Task on failure Case I have a webservice task that sometimes fails (due an external cause) and I want to retry it a couple of times before failing the entire package…
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…