All Containers include a Disable property. This is what is used for the right-click Disable/Enable functionality you may have used when developing packages in the designer. Expressions are evaluated at run-time and can be used to set properties, so it follows that you could use an expression on the Disable property to control execution of… Continue reading Disabling tasks through Expressions
Category: Workflow
Meaning of the On Success Workflow Constraint
What do you think happens in the following trivial package (The first task is disabled)? Nothing. Error. Everything except for the first task executes. Let's take a look Suprised? Well if like us you are coming from a DTS background then it most likely will shock you. In DTS this package would not have got… Continue reading Meaning of the On Success Workflow Constraint
Shredding a Recordset
Doing what to a recordset? Shredding a recordset in this instance means that we are going to show you how to take a recordset produced in your SSIS package, loop over the rows in that recordset, break apart the columns and do something with them. This is really useful when you want to preform an… Continue reading Shredding a Recordset
Looping over files with the Foreach Loop
In SQL Server 2000 Data transformation Services (DTS) it was a bit of a hack to be able to loop over files of a given type in a certain directory and import them into your destination. It involved a lot of "Glue Code" and a certain amount of fooling the package into going back to… Continue reading Looping over files with the Foreach Loop
Parallel Execution Properties
Adjusting the following properties can have an impact on parallelization during execution: 1. MaxConcurrentExecutables This is a property on the Package. It defines how many tasks can be run concurrently. A value of -1 means the number of processors and when hyperthreading is turned on, it counts the number of logical processors, not physically present… Continue reading Parallel Execution Properties
For Loop Container Samples
One of the new tasks in SQL Server 2005 is the For Loop Container. In this article we will demonstrate a few simple examples of how this works. Firstly it is worth mentioning that the For Loop Container follows the same logic as most other loop mechanism you may have come across, in that it… Continue reading For Loop Container Samples
Workflow Constraints – Logical OR
To do some of the stuff we wanted in SQL Server 2000 DTS we had put together some serious glue code and to be honest it wasn't pretty. One of the things that we used to have to do this way was if we wanted to implement using workflow constraints a Logical OR. Well that… Continue reading Workflow Constraints – Logical OR