DTS Package Class Not Registered Error From C++ Application -
03-16-2005
, 07:39 PM
Hello. I have a Windows service written in C++ that imports a text file
to a SQL 2000 SP3 database using a DTS package. It has been running
fine on a Windows 2000 machine. We recently configured a new server
running Windows Server 2003 and SQL 2000 SP3 and now the service gets
the error 80040154 (Class Not Registered) when it trys to instantiate
the DTS object:
ppkgDTS.CreateInstance( __uuidof( DTS::Package ) );
I have re-registered the following dll's on the new server and the
problem still occurs:
dtsffile.dll, dtspkg.dll, dtspump.dll, axscphst.dll, custtask.dll
And I've made sure that the following files are in the correct folders:
sqlresld.dll, dtsffile.rll, dtspkg.rll, dtspump.rll, axscphst.rll,
dtsrun.rll, custtask.rll, sqlunirl.dll
I'm able to run the DTS package manually through Enterprise Manager
with no problems. One difference in the server configurations is that
the W2K server has MDAC 2.6 installed and the W2K3 server has MDAC 2.8.
I'm not sure how to (or if I want to) rollback the W2K3 server to
version 2.6 to see if this is the problem. Any help or ideas would be
greatly appreciated.
Thanks,
Neal |