Have you ever wanted to add more than one Integration Services existing package (e.g. 20 packages) in a SSIS project? Well, you may suppose that an Open Dialog supports multiple files selection to import more than one file at a time ...
BIDS Open Dialog doesn’t allow this, you can just select a single file! Hence the loss of valuable time spent to import the packages one at a time.
Few days ago I learned a trick that solves the problem, thanks to this post by Matt Masson.
Just copy all the packages to import from Windows Explorer (Ctrl + C):
Then just right click on the SSIS Packages folder of the Integration Services project and make a simple Past (CTRL + V):
So “auto-magically” you’ll have all those packages imported in your Integration Services project!!
What can I say... this feature was well hidden!
|re: How to import in BIDS more than one SSIS package in one shot!
This is really a great post. Thanks for genius idea. Keep it up.