Showing posts with the label SCRIPT TASK

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…

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.…

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 co…

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…

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ég…

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 …

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…

Continue Loop after error - Part II

Case I used the propagate variable trick to continue a loop on error. That works within the packag…

Load More That is All