Hello,

I would like to know if it is possible to run a DTS
package from a VB app on a remote workstation that is on
the same network as a Sql Server machine but does not have
sql server loaded on this remote workstation. I have a VB
app that can run a DTS package without any problems if I
run that app on the same machine as the Sql Server
machine. But I would like to run this app on another
workstation. I tried to copy dtspkg.dll to the other
workstation but I was not able to register it. So the VB
app on the remote workstation could not run the dts
package. Is there a way to do this?

Thanks,
Ron

Follow this article and you should be OK

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

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Ron" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Man, I got real busy - lot of fires to put out all of a
sudden. Thanks very much. I will try this out tommorrow
first thing.

Ron