April 16, 2003 at 8:24 pm
Dear all.
I have seached the web and Microsoft Sites with no real results.
I have been able to detemine the following distribution requirements to the Client's PC in order to run a DTS. MSSQL 2000 is not installed - only MySQL installed on the machine. It seems to open the DTS and identify the steps correctly, but when the goPackage.Execute line is executed, the following error appears:
ErrCode: -2147221005
Description : INVALID CLASS STRING
There doesn't seem to be much on this error.
I found all the dlls using dependancy walker but perhaps there may be some dependancy missing or some version problem between MySQL and SQL 2000 dlls.
Has anybody seen this error and if so, where do I start looking ?
Thanks in advance.
Graham
The list of Dll's and their target locations
DTSPKG.DLL - {PF}\Microsoft SQL Server\80\Tools\Binn
SQLDMO.DLL - {PF}\Microsoft SQL Server\80\Tools\Binn
SQLRESLD.DLL- {PF}\Microsoft SQL Server\80\Tools\Binn
SQLSVC.DLL - {PF}\Microsoft SQL Server\80\Tools\Binn
W95SCM.DLL - {PF}\Microsoft SQL Server\80\Tools\Binn
DTSPKG.RLL - {PF}\Microsoft SQL Server\80\Tools\Binn\Resources\1033
SQLDMO.RLL - {PF}\Microsoft SQL Server\80\Tools\Binn\Resources\1033
SQLSVC.RLL - {PF}\Microsoft SQL Server\80\Tools\Binn\Resources\1033
SQLUNIRL.DLL - {sys}
SQLWID.DLL - {sys}
SQLWOA.DLL - {sys}
April 21, 2003 at 12:00 pm
This was removed by the editor as SPAM
April 21, 2003 at 4:44 pm
To the Site Owners.
I must admit that my question is a shot in the dark, as I have search the web (and MS Sites) in order to find an answer - with no results up to now.
April 21, 2003 at 4:59 pm
That list seems close. Tried the lastest DW? http://www.dependencywalker.com. Has a mode to monitor a running process. Might try this link:
http://support.microsoft.com/?kbid=288910
Andy
April 22, 2003 at 3:43 am
Always see the redist.txt file on the disk for these things. But here is the pieces for DTS
quote:
Data Transformation Services (DTS)----------------------------------------------
File NameDescription
----------------------------------------------
sqlresld.dllSatellite Resource DLL Loader
dtsffile.dllDTS Flat File OLE DB Provider
dtsffile.rllDTS Resource File
dtspkg.dllDTS Package
dtspkg.rllDTS Resource File
dtspump.dllDTS Datapump
dtspump.rllDTS Resource File
axscphst.dllDTS ActiveX Script Host
axscphst.rllDTS Resource File
dtsrun.exeCommand Line Utility to Execute a DTS Package
dtsrun.rllDTS Resource File
sqlunirl.dllSQL Server Unicode/ANSI Translation Layer
custtask.dllDTS Custom Tasks File
custtask.rllDTS Custom Tasks Resource File
quote:
INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)---------------------------------------------------------
The following files must be registered using the regsvr32.exe utility:
dtsffile.dll
dtspkg.dll
dtspump.dll
axscphst.dll
Example: regsvr32 80\Tools\Binn\dtsffile.dll
The sqlunirl.dll file should reside in the system folder (i.e., \winnt\system32 or \windows\system).
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply