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 Loo…
Showing posts with the label SCRIPT TASK
Executing a PowerShell script in an SSIS package
byHOIT
Case I want to execute a PowerShell Script within an SSIS package, but there is no PowerShell task.…
Azure File System Task for SSIS
byHOIT
Case There is an upload and download task in the SSIS Azure Pack, but how can I delete a storage co…
Reading sensitive parameters in a script
byHOIT
Case I have a sensitive parameter in my package with a password in it. I want to use it in a Script…
Coming this year... Extending SSIS with .NET Scripting
byHOIT
It's not ready yet, but I'm proud to announce the first SSIS book by me and fellow MVP Rég…
SSIS 2012 Execute Package Task: External Reference does not work with SSISDB
byHOIT
Case I have two SSIS projects (both project deployment) and I within project 'A' I want to …
Retry a Task on failure
byHOIT
Case I have a webservice task that sometimes fails (due an external cause) and I want to retry it a…
Continue Loop after error - Part II
byHOIT
Case I used the propagate variable trick to continue a loop on error. That works within the packag…