SQL Express 2008 with Advanced Services execute SSIS package

Posted on 2011-03-10
Last Modified: 2013-11-10
I have created a SQL 2008 SSIS package on a pc with the standard edition installed.

Now need to execute package on a server with SQL Express 2008 with Advanced Services installed.

Cannot find the DTExec.exe ?

It was included in this edition in 2005 but doesnt appear to be in 2008 ?
Any help would be very much appreciated.
Question by:3Si_pnewman
  • 2

Expert Comment

ID: 35094111
LVL 21

Accepted Solution

Jason Yousef, MS earned 500 total points
ID: 35103126
Sorry Express Edition is not licensed for SSIS, according to microsoft :

Also Check that:

hope that helps

Author Comment

ID: 35154788
I have investigated this fully and the ability to execute a package is only available in sql 2008 standard edition and above. Or sql 2005 express with advanced services.


Author Closing Comment

ID: 35154803
Links to other sites were valuable but not fully explained the reasons for not being able to use the dtexec. one of the links that i followed then followed and other link from that said to install a toolkit which was the 2005 express edition toolkit. this then installed the dtexec and all other tools. However when you try and execute a  package you get a message saying that unable to execute packages, need standard, developer edition or above.

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now