SQL Server Express Using SSIS with SQL Server Express
Question:

I want to use SSIS with SQL Server Express Edition. Is this possible? What other additions do I need to download to do this. I tried installing the SSIS component.
 
I went to the Add/Remove Programs and tried to install a new component to SQL Server 2005 and I keep gettting this error message "The path provided does not correspond to a valid SQL Server 2005 Installation".
 
Please help.
 
 

Answer1:

This is not a part of Express edition.  You need to upgrade to Standard to use SSIS.  Have a look at the integration matrix in the features comparison.
 
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx



-- Jonathan Kehayias (MCITP) | Please mark answers that solve your problem | http://www.sqlclr.net

Answer2:

Hi,
 
SSIS is not included in SQL Express (even though express can be used as a destination or source for SSIS).