Need Help finding ssis packages

13 Jul 2006 6:24 PM

John

Ok, I created an ssis package and saved it inside of sql server. However, I
can't figure out how I can open up packages saved to sql server. I found out
I could save a package to a file system and then open it up later. It gives
me some sort of design view. How can I get the packages saved to sql server
brought up in the management studion?

Thanks

13 Jul 2006 8:30 PM

Sue Hoegemeier

What exactly do you need to do? Do you want to open the
package in the designer? For that, you need to use the
Business Intelligence Development Studio. To open existing
packages, create a new Integration Services project in BID,
right click on the SSIS Packages folder in the Solution
Explorer window and select Add Existing Package.
Do you want to manage the package, run the package? For that
you connect to the Integration Services in Management
Studio.
It just doesn't work like prior versions of SQL Server and
DTS.

-Sue

On Thu, 13 Jul 2006 11:24:02 -0700, John
<J***@discussions.microsoft.com> wrote:

Show quote

>Ok, I created an ssis package and saved it inside of sql server. However, I
>can't figure out how I can open up packages saved to sql server. I found out
>I could save a package to a file system and then open it up later. It gives
>me some sort of design view. How can I get the packages saved to sql server
>brought up in the management studion?
>
>Thanks