by Ellen
17. January 2011 17:36
I’m a firm believer in “develop once, copy many.” I use package templates extensively for my SSIS development projects, and I also reuse packages and redeploy from one project to another for new test or development environments. I always store my packages in the files system because I find them easier to manage that way.
BIDS gives you the option of adding existing packages to your project, but if you choose the Add | Existing Package option from either the project node or the SSIS Packages node in Solution Explorer, you can only add one package at a time.
Tedious.
To add multiple file system packages at once, right click on the package node and choose the Add | Existing Item option instead:
BIDS opens a file explore window and you can select multiple .dtsx files and at them to your project in one swell foop:
Subscribe