Is it possible to have a VB application that allows a user to created a DTS
package from selection made on the VB form. The developer is creating
timesheet exports for different clients. There are many to create. The DTS
package includes connections to dattabases, excel spreadsheets,emailing the
client.

thanks

In message <C6552B35-8D62-4CFC-80CA-0AC0A0BB440D (AT) microsoft (DOT) com>, bj
richard <bj (AT) richard (DOT) ?.microsoft.com.invalid> writes
Yes, you can build a package in memory and then execute it. DTS is just
a COM object model, so you can leverage this from VB. To get some sample
code, build a package in the designer then select Save As Visual Basic
from the package menu.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org