Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Can I run SSIS packages with SQL Server Express or Web or Workgroup editions?

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?

like image 529
Andrew Rimmer Avatar asked Nov 15 '08 13:11

Andrew Rimmer


People also ask

What are the limitations of Microsoft SQL Server Express editions?

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.

What is the difference between SQL Server Standard Edition and Express Edition?

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.

Is SSIS included in SQL Server Enterprise Edition?

Unlike DTS, which was included in all versions, SSIS is only available in the "Standard", "Business Intelligence" and "Enterprise" editions.

Do we need to SQL Server Integration Services to run SSIS packages?

Description: To run a SSIS package outside of SQL Server Data Tools you must install Enterprise Edition of Integration Services or higher.


2 Answers

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.

like image 155
mika Avatar answered Sep 22 '22 02:09

mika


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.

like image 38
John Lemp Avatar answered Sep 24 '22 02:09

John Lemp