While running a feed in SSIS mode it generates an error, where SQL Server 2008 was unable to run a package via DTEXEC. Check to see if SQL Server 2005 is also installed on the same server as SQL Server 2008. If so, then issue is caused by the DTEXEC version of SQL Server 2005 version being executed instead of the SQL Server 2008 DTEXEC version. Since SQL Server 2008 is installed side by side to 2005 and not removed, the 2005 components will run first because they appear first in the PATH environment variable. In otherwards, SQL Server 2005 paths remain in the PATH environment variable first, where the 2008 paths are installed afterwards which means 2005 gets picked up first and then 2008 next. The 2005 version of DTEXEC will run first.
Two solutions exist for this issue, where the first is a quick fix for this DTEXEC issue. The second should be implemented at some point to insure that no other 2005 programs are called by 2008:
SSIS Solutions
1. Renamed the old exe in the 2005 path to a different name (C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTEXEC_OLD.exe)
2. Go to PATH environmental variable and edit it in such a way that "C:\Program Files\Microsoft SQL Server\100\DTS\Binn" path appears well before the "C:\Program Files\Microsoft SQL Server\90\DTS\Binn" path.
Subscribe to:
Post Comments (Atom)
Good solution, we have been seeing a lot of this.
ReplyDelete