I have designed a fairly complex multi-step DTS package. I need to
allow user who don't have a full SQL Server application to run the DTS
package.

While I know how to include the dependent DTS dlls as part of my
installation process, I am wondering if it is actually possible to use
the native SQL Server Execute DTS GUI (which shows all the steps as
well as all current status of steps being executed). This has the
advantage of giving users an indication where the execution is at in
terms of the overall package and can also allow user to pinpoint and
report exactly any error that may occur in one of the steps.

While it is possible to replicate this in code by handling various DTS
events, I am thinking why I should re-invent the wheel if I can re-use
what has already been included in SQL Server.

A complication is that I need to pass variable to the DTS package by
code before executing the package. The default SQL Server DTS Package
gui doesn't allow the setting of any variables.

I am willing to take out the code that pass variables to DTS package if
it means I can use the default DTS GUI.

Any help on this front? Can it be done at all?

Thanx in advance

Try executing the DTS package via ASP.
Pass in parameters using global varialbes.

http://www.sqldts.com/?207


"calvin.wood (AT) gmail (DOT) com" wrote:

Mike

I know how to pass in variables by code. My question is on whether there is
a way to invoke DTS GUI instead of having to write my own GUI.

Thanx

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