Execute a DTS Package from Visual Basic 6

[PrgrmsAll]

Fellow Programmers:
I am attempting to run a DTS Package on a network SQL server from within a very light and simple local Visual Basic application (it literally calls the DTS Package and no more). On my PC, which has full Enterprise installs of both VB6 and SQL Server, the application runs perfectly and remotely executes the DTS Package.

However, when I move this to a test machine, I am getting a "Runtime Error '429': ActiveX component can't create object". I have seen this error before but I am unsure why it would be throwing it in this context.

I have created a installation package and installed it that way. A dependency was the dtspkg.dll library which seemingly installed correctly.

Am I missing something obvious?

Thanks in advance.

 

[MarkSweetland]

See if this Microsoft Article will help you:

http://support.microsoft.com/defaul...s/Q228/9/40.ASP&NoWebContent=1&NoWebContent=1

Mark

"You guys pair up in groups of three, then line up in a circle."
- Bill Peterson, a Florida State football coach