Any help with the below issue would be much appreciated.
I have to migrate a DTS package from a SQL2005 Instance to the SQL2008 instance which is replacing it on the same server..
The 2005 Instance is a default instance and is SQL 2005 64bit Enterprise.
The 2008 instance is named but is the only 2008 instance. It SQL 2008 R2 Standard 64 bit
The server runs under Windows 2008 R2 Enterprise
The DTS package runs under SQL Agent which operates under the same Windows admin account on both instances.
There are no issues with the Agent job on the 2005 instance.
I have tested all the DTS elements individually on the 2008 instance and they function correctly.
The agent job step which runs the DTS is the same in both SQL instances and uses the following command:
DTSRun /S "servername\instancename" /N "DTSPackageName" /E
This will not run returning the error:
the process could not be created for step XX of job ........... (reason 2)
Opening up a command window under Windows and running the code from there succeeds.
I have googled the error but do not seem to find anything relevant.
I have tried running Agent under the local system account as weel as the one that normally runs SQL and Agent, restarting between times and had no joy.
Can someone please advise where I am going wrong?