January 26, 2012

Two Tricks When Adding Packages To A SSIS Project

If you need to add multiple packages to a project you may have noticed that the ‘Add existing package’ option is rather irritating as you have to do it one at the time. So, here is a trick to add several package all at once:
  • Right click in the project name in the solution explorer
  • Select add existing item
  • Navigate to the folder where the packages reside, and use CTRL+left click to select packages.
  • Click the Add button

Wait, you said there were two tricks!

Indeed. Matt Masson shows a different way of doing this in his blog. Actually, was his post the one that prompted me to write mineSmile
As with most things, TMTOWTDI

No comments:

Post a Comment

I will love to hear your feedback and comments. Thanks.