SSIS in Visual Studio without SQL Server 2005 ?

[groleau]

I have SQL Server 2005 Express (free) on this PC (paid version on the way) which I'm told does not have SSIS.

But we also have a paid version of Visual Studio 2005 which allows me to build SSIS packages.

This puzzles me. Will I be able to execute them or store them?

--
Wes Groleau

http://www.Parkview.com/

 

[mrdenny]

You will be able to build them, but you will not be able to upload them to the SSIS service or execute them as you do not have the SSIS service.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com