3

I installed SQL Server 2008 R2 Express edition on a box that already had SQL Server 2008 Developer Edition installed in it. Now Integration Services will not show up in the connect drop-down menu in the object explorer. Any ideas why this is happening? Thanks.

ARK
  • 109
  • 2
  • 2
  • 8
  • I was able to run SSMS as administrator and it gave me a choice of all services during login. – ARK Sep 22 '11 at 05:15
  • Express will not do SSIS: http://stackoverflow.com/q/15514572/153923 –  Aug 02 '13 at 19:28

2 Answers2

7

2 Possibilities spring to mind:

  • You are using Management Studio Express which doesn't support SSIS
  • You have done what I just did & have installed "Management Tools basic" & left out "Management tools - complete"

Either way the solution is to run a SQL 2008 install (not express), choose "add features" & check "management tools - complete"

Sinister China Penguin
  • 81
  • 3
4

There's another angle to this one. If you have SQL Server 2008 already installed, you need to select the upgrade option. If you don't, then in your installation of SQL Server 2008 R2 your "management tools - complete" will be grayed out when you get to the install items choice screen. Hover over it and it will tell you as much. Hope this helps someone.

Barry Jefferson
  • 41
  • 2