Link to home
Start Free TrialLog in
Avatar of 3Si_pnewman
3Si_pnewman

asked on

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.
Avatar of mayankagarwal
mayankagarwal
Flag of India image

ASKER CERTIFIED SOLUTION
Avatar of Jason Yousef
Jason Yousef
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of 3Si_pnewman
3Si_pnewman

ASKER

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.

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.