We created a DTS package that imports data from an Excel
file to a Temporary table and then does an Update to the
primary databse table. The DTS works properly when
executed from
the Enterprise Manager.
What we really want is to allow the End User to execute
the package from the Excel file when they have completed
their changes to the data within the spreadsheet. We got
as far as putting the execute DTS launch command within a
Command button on the Excel file. When it's clicked
nothing happens. We suspect that since the file is
opened that the DTS Package cannot do the import.

Is there a way that we can allow the end user to execute
the DTS when they want to?

Sure you can do this

I am presuming you have registered the DTS dlls ala

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


You then need to call your package with something very similar to

Execute a package from Visual Basic (VB)
(http://www.sqldts.com/default.aspx?208)


Have the package "Fail on First Error"

OR

Have the package log when called the problems it has.

Allan

"Jazz" <jim.abel (AT) lmco (DOT) com> wrote