DTEXEC is not running after upgrading RC0
We upgraded one of our production environments to SQL Server 2008 RC0
After upgrading when we want to run an SSIS package in command prompt by using dtexec we get an error.
Actually even if we run dtexec in command prompt the result is the same.
we get an error message saying "This application has failed to start because DTEParse100.dll was not found. Re-installing the application may fix this problem"
Upvotes: 1<=-=Jul 2 2008 1:44PM=-=>
Thanks for sending us your feedback.
We investigated this issue and its behaving this way by design. When customers upgrade from SQL Server 2005 to SQL Server 2008 RC0, the upgrade process does not remove SQL Server 2005 tools.
Have you tried using DTExec.exe from this folder PROGRAMFILES\Microsoft SQL Server\100\DTS\Binn\? It should work. If it doesn’t please let us know.
The workaround would be to set the “PATH” environment variable to include SQL Server 2008 binn path (i.e. PROGRAMFILES\Microsoft SQL Server\100\DTS\Binn\) before the SQL Server 2005 binn path (i.e. PROGRAMFILES\Microsoft SQL Server\90\DTS\Binn\) so that the right toolset gets used.