I have looked at the SQL Server 2008 feature comparison matrix and it lists the express/web and workgroup editions as having the SSIS runtime. Does this mean it is possible to develop SSIS packages using the developer edition, and then deploy and run them on a server running one of the lowly SQL Server editions such as SQL Server 2008 Express edition?
Express edition limitations Microsoft SQL Server Express has a 10 GB maximum database size and other important limits. High load scenarios are not supported by Express. Symptoms can include database connection errors. Express has a "LocalDB" preset.
SQL Express is free, but requires a bit more RAM to perform well. SQL Standard has a licence costs but Your Office Anywhere are able to significantly reduce the licence burden for customers by using data centre licences and running multiple secure instances of SQL on multi-tenanted servers.
Unlike DTS, which was included in all versions, SSIS is only available in the "Standard", "Business Intelligence" and "Enterprise" editions.
Description: To run a SSIS package outside of SQL Server Data Tools you must install Enterprise Edition of Integration Services or higher.
You need dtexec to run SSIS packages from command line.
In SQL2005 Express you got dtexec and necessary tools with
However, without SQL Agent you have to use other scheduling methods.
More information: http://daron.yondem.com/default.aspx?month=2006-05
Caveat: I haven't actually tried this and there are reports that dtexec just fails with a licence error. In my case, I just needed to run a dtsx once and did it with Developer edition with SQLExpress as data flow destination.
The workgroup edition only has primitive import and export capabilities. As far as I can confirm, if you want to create SSIS packages using any data transformations you need to get SQL standard edition or higher.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With