Saturday, February 25, 2012

Adding Integration Services to the existing Sqlserver 2005 - Question

Hello to everybody,

Installed the Integration Services to the existing Sqlserver 2005. But I am not seeing the 'Integration Services' in the

SQL Server Management Studio, like the 'SQL Server Agent' in the server. I am not sure what the next step is after installing the 'Integration Services'. Appreciate any help on this. Thanks for your time in advance.

Thanks,
Gopal.

It's a different server type, like Analysis Services. When you start a new connection, choose Integration Services instead of Database Engine.

|||

Also please notice that you should be doing most SSIS work in BIDS (Business Intelligence Dev Studio), not in SSMS. I recommend starting with Books Online or the Guided Tour: http://www.microsoft.com/sql/technologies/integration/tours.mspx, in particular Visual Development Environment Guided Tour.

No comments:

Post a Comment