sql server dts: Hi,

Im trying to set up an ASP that will trigger a DTS package. Have seen
the example on sqldts.com:

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

And I can get his working OK. How would one alter this code to
include any globals variables that I want to pass to the DTS package?

Thanks,

Red.

[quoted text, click to view]

Rather than start a new post, i'll tag my other question on to this.

The code on the page above loops through all tasks within the package,
and writes the outcome to the page. However, for tasks that are not
run, it shows them as failed. This seems not quite right, as the line
of code to check the step status is:

If oStep.ExecutionResult = DTSStepExecResult_Failure Then

But the results seem to indicate that if the step was not run, it is
seen as failed, when in fact it should say 'Not Run'.

Ideally I would like to alter this code to only show the steps that
the package tried to execute, and ignore those not called. Can this
be done? Alternatively, can I check whether the step was called or
not?

Thanks (again),

Red.