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?