Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 deploy dtspkg.dll

Author  Topic 

Hommer
Aged Yak Warrior

808 Posts

Posted - 2005-09-28 : 15:37:39
I used vb6 package and deploy wizzard to create the setup.exe. The vb6 app will fire a SQL Server DTS as needed.

I got run-time error 429 "ActiveX Component cann't create object".
I am pretty sure it is dtspkg.dll, because that is the only dll I have there.

I tried to run regsvr32 dtspkg.dll or regsvr32 "C:\FilePath\dtspkg.dll" in cmd, and got "the specified module could not be found".

The dll on my machine is sitting at C:\Program Files\Microsoft SQL Server\80\Tools\Binn, and the app runs fine.

It is also on users’ machine, but the app wouldn't run!

Could it be other dependency file?

Should the P&D wizard pick up those dependency files as well?

Besides, I did not use dts data pump or any other fancy stuff like event handler.

What else should I do?

Thanks!

Hommer
Aged Yak Warrior

808 Posts

Posted - 2005-09-28 : 16:21:24
I found this excellent article about redistributing DTS by Darren Green at
http://www.sqldts.com/default.aspx?225

I will check each of these files out.
Go to Top of Page
   

- Advertisement -