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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
ASKER
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.
http://msdn.microsoft.com/en-us/library/ms162810.aspx