dbTalk Databases Forums  

DTS Package Class Not Registered Error From C++ Application

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS Package Class Not Registered Error From C++ Application in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
wcmsuser
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.