Tips ‘N’ Tricks – SSIS – Update Properties of Multiple Tasks in One-Go
While working with SSIS Packages, we set various properties at different levels like Package Level, Container/Task Level, Data Flow Level and so on. Sometimes, we set the same property to a particular value for multiple tasks in the control flow. For example, there are various properties which are common to different types of tasks like DelayValidation, Disable, DisableEventHandlers, FailPackageOnFailure, and the list goes on. Now, let us say you want to set the DelayValidation property to True for multiple tasks within the SSIS Control flow, then here is a simple technique to do that in just no time by following the below mentioned steps.
Hold the Ctrl Key
Select all the Tasks (Which have the same property, in this case it’s DelayValidation)
In the Properties Window, just change the DelayValidation Property to True as shown in the below screenshot and that’s it!
This can be really handy, especially when you are dealing with large number of tasks and want to set one or more similar properties for multiple tasks to the same value and it can save you a lot of time 🙂
Take a look at the other Tips and Tricks in this Series on Tips, Tricks, Techniques, and Shortcuts to Improve Productivity, and Design and Coding Skills.
Posted on May 18, 2012, in BIDS, Shortcuts, SQL Client Tools, SQL Server, SSIS, SSIS Tips, Tips 'N' Tricks and tagged BIDS, Control Flow, Microsoft SQL Server, Shortcuts, SQL Server, SQL Server Business Intelligence Development Studio, SSIS, Tips, Tips and Tricks, Tricks. Bookmark the permalink. 3 Comments.