Hi
How can I get the DTS detail error information? Is
there any method of function like GetExecutionErrorInfo in
VB? I got the "Package failed because
Step 'DTSStep_DTSDataPumpTask_1' failed. -2147220440"
error. But I don't know why. the err.Description doesn't
work fot it.
Any suggestion?

You cannot use GetExecutionErrorInfo from ASP, or any of the common script
languages, as they do not support strong types.
GetExecutionErrorInfo uses ByRef parameters which only work when passed the
exact type, hence you need VB or similar.

Use a COM component for example. Sample available here-
Execute a package from Active Server Pages (ASP)
(http://www.sqldts.com/default.aspx?207)


--
Darren Green
http://www.sqldts.com

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