How to import in BIDS more than one SSIS package in one shot!

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! Smile

Comments

  1. Gravatar Damodar says:

    Re : # 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.

    Regards,
    P.Damodar
Comments have been closed on this topic.