Friday, February 24, 2012

Integration Services missing from Management Studio

I have installed SQL Server 2005. I am able to create and edit
Integration services packages from VS but the Management Studio does
not show a folder for Integration Services so I can manage the
packages from within the Management Studio itself. From what I can
tell from the documentation, I should be able to see and manage them
from within Management Studio. What am I missing?
(markthompson23@.gmail.com) writes:
> I have installed SQL Server 2005. I am able to create and edit
> Integration services packages from VS but the Management Studio does
> not show a folder for Integration Services so I can manage the
> packages from within the Management Studio itself. From what I can
> tell from the documentation, I should be able to see and manage them
> from within Management Studio. What am I missing?
To work with SSIS you need to use Business Intelligence Development
Studio, that is VS. There is not much you can do with SSIS from Mgmt
Studio.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

No comments:

Post a Comment