Hi Guys, How do you load a package stored in integration services catalog from SSDT? or should I load the entire project? MCTS, MCITP: BI Technical Consultant| Karabina, South Africa

You load the entire project. Catalog items are designed to be dealt with as a unit since they can contain shared resources (connections/parameters)Chuck Pedretti | Magenic North Region | magenic.com

Hey Chuck, How do you load the project? from SSMS or SSDT? MCTS, MCITP: BI Technical Consultant| Karabina, South Africa

If you do not have the original source (which you should have in source control somewhere) Then select export from the menu you showed and save it back to your local drive. Chuck Pedretti | Magenic North Region | magenic.com

the export option save the project as a deployment file. MCTS, MCITP: BI Technical Consultant| Karabina, South Africa

Yes. Then open up SSDT and select new project - then pick integration services import project wizard. You can load the ispac file there. Edit: Looks like you can also just pull straight from the catalog using that wizard if you have connectivity to the server. Chuck Pedretti | Magenic North Region | magenic.com

it works. I appreciate it, Chuck. Many thanks.MCTS, MCITP: BI Technical Consultant| Karabina, South Africa Blog: www.selectsifiso.net