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.


About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on May 18, 2012, in BIDS, Shortcuts, SQL Client Tools, SQL Server, SSIS, SSIS Tips, Tips 'N' Tricks and tagged , , , , , , , , , . Bookmark the permalink. 3 Comments.

  1. Generally I don’t read article on blogs, however I would like to say that this write-up very forced me to check out and do it! Your writing taste has been surprised me. Thanks, very nice post.

  1. Pingback: Tips ‘N’ Tricks – Tips, Tricks, Techniques, and Shortcuts to Improve Productivity, and Design and Coding Skills « Datta's Ramblings on Business Intelligence 'N' Life

  2. Pingback: SSIS – SQL Server Integration Services Connection Manager Tips and Tricks | Datta's Ramblings on BI 'N' Life

What are your thoughts?

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: