sql server dts: "COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not -- sql server dts

"COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not

Leezard via SQLMonster.com
5/5/2005 7:10:48 PM

sql server dts:

I created a dts package that imports data into sqlserver. I run the dts
package from a vb.net application on a machine that does not have sqlserver
installed. I get the error quoted above. I used an installer project to
install my vb.net application on the machine running the application.
Included in the folder with my exe is dtspkg.dll, Interop.DTS.dll, as well

Re: "COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not

Allan Mitchell
5/5/2005 8:30:04 PM

Have you followed this article on the box running the package

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

AND

http://www.sqldev.net/dts/DotNETCookBook.htm

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com

[quoted text, click to view]