Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a production SQL Server 2008 running on Windows Server and I do testing and development on my laptop. My laptop is running Win XP and SQL Server Express 2008. In addition to having SQL Server Express I would like to install SSIS from the full SQL server on my laptop. I realize that SSIS does not come with SQL Server Express. But it does come with SQL Server 2008, which I have. I would like to install SSIS 2008 on my laptop along with SQL Server Express in order to build my ETL routines locally and then deploy them later to my production server.

I can't figure out how to install ONLY SSIS on my laptop using the SQL Server 2008 install media (Clarification: NOT the SQL Server Express media). When I get to the "Feature Selection" step in the SQL Server Complete install, the options to install "Database Engine Services" and "SQL Server Replication" are checked but gray so I can't un-check them.

How do I install only SSIS on my laptop?

A related question would be "is it possible to install SSIS on a computer which does not have any version of the SQL Server DB installed?" I get the feel that many people think of SSIS as "part of" SQL Server, but it's a stand alone app that can connect to any SQL Server on any machine. Why should it need to install SQL Server on my laptop in order for me to do ETL on my server?

Am I just thinking about this wrong?

share|improve this question
add comment

3 Answers

up vote 5 down vote accepted

After continuing to dig around I finally found an article in MSDN that covers installing advanced services without installing SQL Server. That got me pointed in the right direction:

The Crux of my mistake is that I thought of this as 'adding a feature to an existing instance of SQL Server 2008.' Therein lies my flaw. In the install process there is an option for 'Installation Type.' What I should have marked was 'perform a new installation of SQL Server 2008.' (even though I already have 2008 Express installed)

Then when I get to the section with the License Terms I had to select my key, ctrl+x to cut it out the license key (it was correct), then ctrl+p to paste it back, THEN click next. Otherwise I would get the Express install, not the regular install. Apparently an 'on key' or 'on click' event was not being properly captured.

At that point I could add SQL Server (non express) features to my laptop. The most important check box for SSIS is 'Integration Services'

It appears that there are a few things that are confusing in the wording and a few things buggy in the tool flow.

share|improve this answer
    
Installing SQL 2005+ has been pretty smooth for me. You can't expect a full licensed product to install over a crippled/lite version. –  Sam Aug 5 '09 at 3:11
1  
I don't understand the assertion that I can't expect SSIS to load on a machine with SQL Server Express. Seems rational to me, but I am subject to first person bias. :) –  JD Long Aug 5 '09 at 18:10
    
What a clever trick (cut-and-paste), just installed SSIS on machines where SQL Express 2008 is already installed (originally only DB Engine was shown under Feature Selection). Thank you –  jerryhung Dec 2 '11 at 20:30
add comment

SSIS isn't included in SQL Server Express edition. Is your question mistagged, or are you really using an express install?

It should be possible if you're using a SKU that has SSIS included (per BOL). Have you tried a Command-Line install?

share|improve this answer
    
I'll try to clarify my question since two different folks have misunderstood me. –  JD Long Aug 4 '09 at 19:23
add comment

Those options are greyed out because, as Aaron already mentioned, SSIS isn't available with SQL Server Express and that is the only version you have installed on your laptop.

You'll have to get the Developer Edition, Enterprise Edition or Standard edition on your laptop.

share|improve this answer
    
I have the full SQL Server media (standard edition) and I want to install from that media only SSIS onto a machine that has SQL Server Express 2008 already on it. Possible? –  JD Long Aug 4 '09 at 19:42
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.