Friday, March 07, 2008

Retrieve a saved package into Visual Studio 2005

Say, you have a package stored in your Integration Services Server adn you want to bring it up into Visual Studio.

This is what you need to do:

Create a BI Project. Right click the SSIS Packages node in the Solution Explorer and choose Add Existing Package.This brings up the screen where you need to locate the package you want to bring it in. You need to know the name of your server; provide authentication, and identify the packge on the server, or file system as shown in the following figure.

If you are a beginner I suggest you take a look at my book which will bring you up to speed in under two weeks.

No comments: Protection Status