• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1041
  • Last Modified:

SQL Express 2008 with Advanced Services execute SSIS package

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.
  • 2
1 Solution
Jason Yousef, MSSr. BI  DeveloperCommented:
Sorry Express Edition is not licensed for SSIS, according to microsoft :


Also Check that:


hope that helps
3Si_pnewmanAuthor Commented:
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.

3Si_pnewmanAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now