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

sql-server sql-server-2008 ssis
Andrew Rimmer picture Andrew Rimmer · Nov 15, 2008 · Viewed 61.8k times · Source

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?

Answer

mika picture mika · Nov 18, 2008

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.

Related questions

How do I fix 'Invalid character value for cast specification' on a date column in flat file?

I have a CSV file with a {LF} delimiting each row and a date column with the date format as "12/20/2010" (including quotation marks) My destination column is a SQL Server 2008 database table of type date (not datetime) In my Flat …

Read More
Temporarily disable all foreign key constraints

I am running an SSIS package which will replace data for a few tables from FlatFiles to existing tables in a database. My package will truncate the tables and then insert the new data. When I run my SSIS package, …

Read More
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server import/export wizard and I went through the following actions:- for the destination I chose "SQL server native client 10". …

Read More