Is it possible to write a VB installation package that will install a DTS
package on a client (third party) remote site that has MSDE only. MSDE will
be installed as part of the installation package. The program that we have
created requires DTS to import data from DBASE into SQL, but so far I haven't
found a way to install a DTS package from a VB application program. Or if
there any other way to do it than via VB than would help as well. I am sort
of desperate and I would appreciate any help.

http://msdn.microsoft.com/library/de...thobj_0zlg.asp

This could be used by envoking SaveToSQLServer Method method but i do not
know what dll;s are required on the machine running it. Maybe it could be
distro'd with the VB app.....or Using VB.net an Interop....

Any help?

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

Your options may depend on the install program you're using and the
customizations that it offers.

Of course, you can easily just copy the the package into the file system as
a structured storage file (usually *.dts).

If you want to save it to SQL Server instead, you could write code to load
the package into memory, perhaps from a temporary copy of the .dts file,
then call the SaveToSQLServer method .

Note that your client will also need the DTS DLL's listed in the SQL Server
REDIST.TXT.

-Doug
--
Douglas Laudenschlager
Microsoft SQL Server documentation team
Redmond, Washington, USA

This posting is provided "AS IS" with no warranties, and confers no rights.

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