Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1035
  • 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.
0
3Si_pnewman
Asked:
3Si_pnewman
  • 2
1 Solution
 
mayankagarwalCommented:
0
 
Jason Yousef, MSSr. BI DeveloperCommented:
Sorry Express Edition is not licensed for SSIS, according to microsoft :

http://msdn.microsoft.com/en-us/library/cc645993.aspx

Also Check that:

http://stackoverflow.com/questions/292564/can-i-run-ssis-packages-with-sql-server-2008-express-web-or-workgroup


hope that helps
Jason
0
 
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.

0
 
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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