I installed SQL Server 2008 Workgroup version that I downloaded from MSDN
subscription site, and I want to use the Integration Services. But each time
I try to select the Integration Services in Management Studio, it tells me
it's not installed as a service on my server.

I tried to run the SS2008 again to add the feature, but I can't because it's
already checked as an installed share feature.

How can I get Integration Services to work? I have SQL Express and SQL
Server 2005 (both installed automatically by Visual Studio 2008 --separate
instances). All of these are installed on my desktop (development machine).

Any help would be greatly appreciated.

Hi Marilyn

What happen if you go to SQL Server Configuration Manager, do you by any
chance see SQL Server Integration Services in there?

Also do you installed SQL Server 2008 as named instance? You also mentioned
that you have SQL Server 2005, do you by any chance have SSIS installed for
SQL Server 2005? I know that we can only have one instance of SSIS.

Thank you
Lucas

"Marilyn" wrote:

Lucas Kartawidjaja (LucasKartawidjaja (AT) discussions (DOT) microsoft.com) writes:
I seem to have two services on my machine, one called SQL Integration
Services and one called SQL Integration Services 10.0.

I think Marylin's problem may be that in Workgroup edition, the available
feature set of Integration Services may not be sufficient to permit a
connect from SSMS. According to Books Online, these SSIS features are
supported in Workgroup Edition:

o SQL Server Import and Export Wizard with the Execute SQL task and basic
sources, transformations, and destinations

o Integration Services runtime

o Integration Services API and object model

I don't think there is much you can do with Integration Services from SSMS
anyway. The prime venue for dealing with Integration Services is
Business Intelligence Development Studio. However, this component does not
ship with Workgroup Edition.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi,

Thanks for the reply. I just uninstalled the workgroup version and
installed the standard version for SQL Server 2008. That works.

Thanks for the replies.

"Erland Sommarskog" wrote: