dbTalk Databases Forums  

DTSRUN.EXE error

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


Discuss DTSRUN.EXE error in the microsoft.public.sqlserver.dts forum.



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

Default DTSRUN.EXE error - 01-06-2004 , 10:34 AM






Hello,
From my client, through Windows Explorer, I'm executing a
DTS on our network server(Win2000), but I get this error:

"C:\WINDOWS>"\\acs4
\Binn\dtsrun" /Sacs4 /Ndts_Denso_CO_Item_Upload /E
DTSRun: Cannot create COM Server to load and execute DTS
Package. Error -21472
21164 (80040154): Class not registered"

Do you know what this error is, and how I can run this
DTS from my client machine? The DTS runs fine when
executed from the server console.

Thanks,
John

Reply With Quote
  #2  
Old   
Ozone
 
Posts: n/a

Default Re: DTSRUN.EXE error - 01-06-2004 , 11:12 AM






When you run the DTS run command it is executed on the system that started
the command, Therefore, all of the COM objects used in the DTS package need
to be registered on the local system, If this is not your problem, look in
the application event log and see if there are any errors in there and post
them.

Ozone
"John Walker" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello,
From my client, through Windows Explorer, I'm executing a
DTS on our network server(Win2000), but I get this error:

"C:\WINDOWS>"\\acs4
\Binn\dtsrun" /Sacs4 /Ndts_Denso_CO_Item_Upload /E
DTSRun: Cannot create COM Server to load and execute DTS
Package. Error -21472
21164 (80040154): Class not registered"

Do you know what this error is, and how I can run this
DTS from my client machine? The DTS runs fine when
executed from the server console.

Thanks,
John



Reply With Quote
  #3  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: DTSRUN.EXE error - 01-07-2004 , 02:13 AM



Here you go

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"John Walker" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hello,
From my client, through Windows Explorer, I'm executing a
DTS on our network server(Win2000), but I get this error:

"C:\WINDOWS>"\\acs4
\Binn\dtsrun" /Sacs4 /Ndts_Denso_CO_Item_Upload /E
DTSRun: Cannot create COM Server to load and execute DTS
Package. Error -21472
21164 (80040154): Class not registered"

Do you know what this error is, and how I can run this
DTS from my client machine? The DTS runs fine when
executed from the server console.

Thanks,
John



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.