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
as some other config and dll files. Why am I getting this error?

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


"Leezard via SQLMonster.com" <forum (AT) nospam (DOT) SQLMonster.com> wrote