Does anyone know of a code sample or third party object to programmatically
save a dts package to VB code like you can from the DTS Designer? I'd rathe
rnot write my own scripter.

Thanks,
Steve Waldner

Ok, so you create the DTS from Enterprise Manager and create this VB
application. It works like a charm on your computer. So you package it
and install it on another computer and you go through and register all
of the DLLs. The user runs the application and you get Run-time Error
'-2147221005 (800401f3)': Invalid Class String



What else does the other computer need to run this? Do I have to install
Enterise Manager on their computer? I hope not.



Thanks for any help.


--
Posted via http://dbforums.com

If you've registered all the dlls and placed in the correct directories etc
then you may be seeing this

Service Pack and Version Compatibility Problems
(http://www.sqldts.com/default.aspx?223)

--
--

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

"kghott" <member47354 (AT) dbforums (DOT) com> wrote