asked on

Can I use SSIS within SQL Server 2008 Express?

I'd like to build SSIS packages in Visual Studio 2008 to run on SQL Server 2008 Express. It appears SSIS doesn't come with the Express version nor within Visual Studio 2008. Correct? If I have a copy of SQL Server 2008 Standard, can I load SSIS from there without loading the entire SQL Server 2008 Standard, and get it to work with the Express version and VS 2008?

Thanks,
Gary

ASKER CERTIFIED SOLUTION

rmm2001

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

chapmandew

SSIS is a separate service (not part of the db engine), that you have to license (part of the standard license).

Reza Rad

you can just install SSIS
by selecting Integration Service in sql server setup. and this will just install SSIS

chapmandew

Right...but you have to pay for it. SSIS is a licensed product, not free like sql 2008 express.

garyphunt

ASKER

Thanks for all these responses.

So far the most helpful was the link rmm2001 sent. However, two things I want to verify 1) I will be able to install SSIS from a SS Standard package onto an XP machine, 2) I then will be able to use it on XP along with VS 2008 and run it on SS Express.

My alternative is to build a MS Server 2003 virtual machine, install the full version of SS Standard on it, and then connect from the base XP machine to the VM. Seems kind of round about since all I need is SS Express. But if you guys tell me I have to do this, then I guess I will.

Thanks,
Gary

SOLUTION