by Tina » Fri, 13 Jul 2001 04:47:15
I am trying to setup a job to run DTS using DTSrun
utility. I tested in SQL2000, it was fine, but in SQL 7.0
I have this error "DTSRun: cannot create COM Server to
load and execute DTS Package - Error -2147221164(80040154)
Class not registered".
Any one know the reason why. Please help.
Thanks a lot.
Tina,
by Gabriele Pont » Fri, 13 Jul 2001 05:47:15
Gabriele
Quote:> Hi,
> I am trying to setup a job to run DTS using DTSrun
> utility. I tested in SQL2000, it was fine, but in SQL 7.0
> I have this error "DTSRun: cannot create COM Server to
> load and execute DTS Package - Error -2147221164(80040154)
> Class not registered".
> Any one know the reason why. Please help.
> Thanks a lot.
> Tina,
by Tina » Fri, 13 Jul 2001 06:24:59
Tina,
PS: I am using 2 different machines
> Gabriele
>> Hi,
>> I am trying to setup a job to run DTS using DTSrun
>> utility. I tested in SQL2000, it was fine, but in SQL
7.0
>> I have this error "DTSRun: cannot create COM Server to
>> load and execute DTS Package - Error -2147221164
(80040154)
>> Class not registered".
>> Any one know the reason why. Please help.
>> Thanks a lot.
>> Tina,
>.
by Euan Garde » Fri, 13 Jul 2001 15:34:38
-Euan
> Tina,
> PS: I am using 2 different machines
> >-----Original Message-----
> >Are you using two different machines? If so, I guess that
> since they are
> >different versions, the COM objects are also different so
> dtsrun cannot
> >initialize the package.
> > Gabriele
> >> Hi,
> >> I am trying to setup a job to run DTS using DTSrun
> >> utility. I tested in SQL2000, it was fine, but in SQL
> 7.0
> >> I have this error "DTSRun: cannot create COM Server to
> >> load and execute DTS Package - Error -2147221164
> (80040154)
> >> Class not registered".
> >> Any one know the reason why. Please help.
> >> Thanks a lot.
> >> Tina,
> >.
by Tina » Sat, 14 Jul 2001 03:37:16
"DllRegisterServer in f:\mssql7\binn\dtspkg.dll failed.
Return code was 0x80004002"
Please help.
Tina,
>-Euan
>> Thank you for your help. But I don't know what I should
>> do from here. Can you tell me what should I do to make
>> Dtsrun can initialize the package.
>> Tina,
>> PS: I am using 2 different machines
>> >-----Original Message-----
>> >Are you using two different machines? If so, I guess
that
>> since they are
>> >different versions, the COM objects are also different
so
>> dtsrun cannot
>> >initialize the package.
>> > Gabriele
>> >> Hi,
>> >> I am trying to setup a job to run DTS using DTSrun
>> >> utility. I tested in SQL2000, it was fine, but in
SQL
>> 7.0
>> >> I have this error "DTSRun: cannot create COM Server
to
>> >> load and execute DTS Package - Error -2147221164
>> (80040154)
>> >> Class not registered".
>> >> Any one know the reason why. Please help.
>> >> Thanks a lot.
>> >> Tina,
>> >.
>.
by Euan Garde » Sat, 14 Jul 2001 04:29:29
-Euan
> "DllRegisterServer in f:\mssql7\binn\dtspkg.dll failed.
> Return code was 0x80004002"
> Please help.
> Tina,
> >-----Original Message-----
> >Read the redist.txt on the cd it explains what you need
> ot do to register a
> >the DTS com objects, this is most likely your problem.
> >-Euan
> >> Thank you for your help. But I don't know what I should
> >> do from here. Can you tell me what should I do to make
> >> Dtsrun can initialize the package.
> >> Tina,
> >> PS: I am using 2 different machines
> >> >-----Original Message-----
> >> >Are you using two different machines? If so, I guess
> that
> >> since they are
> >> >different versions, the COM objects are also different
> so
> >> dtsrun cannot
> >> >initialize the package.
> >> > Gabriele
> >> >> Hi,
> >> >> I am trying to setup a job to run DTS using DTSrun
> >> >> utility. I tested in SQL2000, it was fine, but in
> SQL
> >> 7.0
> >> >> I have this error "DTSRun: cannot create COM Server
> to
> >> >> load and execute DTS Package - Error -2147221164
> >> (80040154)
> >> >> Class not registered".
> >> >> Any one know the reason why. Please help.
> >> >> Thanks a lot.
> >> >> Tina,
> >> >.
> >.
by Tina » Sat, 14 Jul 2001 06:29:23
>-Euan
>> Thanks for your info. I have tried to follow the
>> instruction in redist.txt. I could register
dtsffile.dll
>> and exscphst.dll, but got error with dtspkg.dll and
>> dtspump.dll
>> "DllRegisterServer in f:\mssql7\binn\dtspkg.dll failed.
>> Return code was 0x80004002"
>> Please help.
>> Tina,
>> >-----Original Message-----
>> >Read the redist.txt on the cd it explains what you need
>> ot do to register a
>> >the DTS com objects, this is most likely your problem.
>> >-Euan
>> >> Thank you for your help. But I don't know what I
should
>> >> do from here. Can you tell me what should I do to
make
>> >> Dtsrun can initialize the package.
>> >> Tina,
>> >> PS: I am using 2 different machines
>> >> >-----Original Message-----
>> >> >Are you using two different machines? If so, I guess
>> that
>> >> since they are
>> >> >different versions, the COM objects are also
different
>> so
>> >> dtsrun cannot
>> >> >initialize the package.
>> >> > Gabriele
>> >> >> Hi,
>> >> >> I am trying to setup a job to run DTS using DTSrun
>> >> >> utility. I tested in SQL2000, it was fine, but in
>> SQL
>> >> 7.0
>> >> >> I have this error "DTSRun: cannot create COM
Server
>> to
>> >> >> load and execute DTS Package - Error -2147221164
>> >> (80040154)
>> >> >> Class not registered".
>> >> >> Any one know the reason why. Please help.
>> >> >> Thanks a lot.
>> >> >> Tina,
>> >> >.
>> >.
>.
by Euan Garde » Thu, 19 Jul 2001 14:53:10
-Euan
> >-----Original Message-----
> >Do you have the .rll's in a sub directory under where
> the .dlls are?
> >-Euan
> >> Thanks for your info. I have tried to follow the
> >> instruction in redist.txt. I could register
> dtsffile.dll
> >> and exscphst.dll, but got error with dtspkg.dll and
> >> dtspump.dll
> >> "DllRegisterServer in f:\mssql7\binn\dtspkg.dll failed.
> >> Return code was 0x80004002"
> >> Please help.
> >> Tina,
> >> >-----Original Message-----
> >> >Read the redist.txt on the cd it explains what you need
> >> ot do to register a
> >> >the DTS com objects, this is most likely your problem.
> >> >-Euan
> >> >> Thank you for your help. But I don't know what I
> should
> >> >> do from here. Can you tell me what should I do to
> make
> >> >> Dtsrun can initialize the package.
> >> >> Tina,
> >> >> PS: I am using 2 different machines
> >> >> >-----Original Message-----
> >> >> >Are you using two different machines? If so, I guess
> >> that
> >> >> since they are
> >> >> >different versions, the COM objects are also
> different
> >> so
> >> >> dtsrun cannot
> >> >> >initialize the package.
> >> >> > Gabriele
> >> >> >> Hi,
> >> >> >> I am trying to setup a job to run DTS using DTSrun
> >> >> >> utility. I tested in SQL2000, it was fine, but in
> >> SQL
> >> >> 7.0
> >> >> >> I have this error "DTSRun: cannot create COM
> Server
> >> to
> >> >> >> load and execute DTS Package - Error -2147221164
> >> >> (80040154)
> >> >> >> Class not registered".
> >> >> >> Any one know the reason why. Please help.
> >> >> >> Thanks a lot.
> >> >> >> Tina,
> >> >> >.
> >> >.
> >.
1. DTSRun.exe does not run in SQL7.0
Hi,
I am having problem to run DTSRun.exe in SQL7.0 the error
refer to "COM and class not register". I have followed
the instruction in redist.txt file in SQL7 CD and tried to
register all dts related dll's. There were 2 dll's that I
could not register (dtspkg.dll, and dtspump.dll)
The below is the instruction from redist.txt file that I
am talking about.
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 \mssql7\binn\dtsffile.dll
The sqlwoa.dll and sqlwid.dll files should reside in the
system folder (i.e., \winnt\system32 or \windows\system).
Thanks in advance for any help.
2. Change max-number logins to zero
4. HELP: D1 database prg under Win95????
5. Package runs in EM - doesn't from ISQL / Command LIne DTSRun
6. Disabled bound text box not updating
7. Scheduled Job doesn't run EXE
8. INSERT with Excel ODBC driver?
10. .EXE running from AT service on NT won't run with ORACLE ODBC
11. Running DTSRUN for multiple instances of SQL2000 on same machine
12. Win 2000 exe runs fine on 98 but crashes on 95 and NT