SSIS With Sql Server 2005 Express

Can we use SSIS with SQL Server (2005) Express as database?

Solution 1:

SQL Server Express editions don't come with SSIS package. Please check this http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

One way to get around it is to build SSIS packages on Standard Edition and copy them. Here, this might be handy http://daron.yondem.com/PermaLink.aspx?guid=c44d040b-ed02-4330-a662-4cd9d6fb1bf3

cheers