Re: How can I get the DTS error when I code ASP page?
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 07/09/04
- Next message: Larry Charlton: "Permission Denied for CreateObject"
- Previous message: Allan Mitchell: "Re: Step Error Description:The Data Pump Task requires Transformations to be specified."
- In reply to: kevin: "How can I get the DTS error when I code ASP page?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 9 Jul 2004 11:10:57 +0100
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@discussions.microsoft.com> wrote in message news:299c001c46568$719e2410$a401280a@phx.gbl... > 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?
- Next message: Larry Charlton: "Permission Denied for CreateObject"
- Previous message: Allan Mitchell: "Re: Step Error Description:The Data Pump Task requires Transformations to be specified."
- In reply to: kevin: "How can I get the DTS error when I code ASP page?"
- Messages sorted by: [ date ] [ thread ]
