Re: Revealing error info from objects instanced in script tasks

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 11/15/04 

Date: Mon, 15 Nov 2004 20:28:23 +0000

In message <uF1caW0yEHA.2316@TK2MSFTNGP15.phx.gbl>, Lee Gillie
<Lee@nospam.odp.com> writes
>I am programmatically loading and executing packages from VB.NET. When
>ActiveX script tasks instance objects, such as ADO, and those objects
>fail, the only error indication I get is a GENERAL DTS error. The error
>of the underlying object, from the script, is lost. For example, ADO
>COMMAND TIMEOUT.
>
>In the VB.NET code which executes the package, I trap exceptions at
>execution, I report all available error indicators I can find, and I do
>a post-mortem dump of the error data in the steps, but no where do I
>see the scripted object error indicator.
>
>The pattern seems to be when ActiveX instances an object, and IT has an
>error, then it perculates up through DTS as a "general error", which
>hides the real problem. Is there ANY way to get more diagnostic
>information when executing programmatically?
>
>I am sure this must have been asked before, but I researched some FAQ
>and could not find it.

Try using events, as sometimes this can give you more info than the
GetExecutionErrroInfo method from the step.

HOW TO: Use DTS Package Events in Visual Basic .NET
(http://support.microsoft.com/default.aspx?scid=kb;en-us;321525) 

-- 
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com
PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Relevant Pages

  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... I have seen some scripts executing from a ... Gouvernement du Canada / Government of Canada ...
    (comp.os.linux.development.apps)
  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... takes root privileges to do so. ... I have seen some scripts executing from a ...
    (alt.os.linux.redhat)
  • QUESTION: shared libraries
    ... how would I create a package easy-to-install for a new user? ... we could use a script to install the package. ... takes root privileges to do so. ... I have seen some scripts executing from a ...
    (comp.os.linux.development.system)
  • Revealing error info from objects instanced in script tasks
    ... I am programmatically loading and executing packages from VB.NET. ... ActiveX script tasks instance objects, such as ADO, and those objects ... the only error indication I get is a GENERAL DTS error. ... For example, ADO ...
    (microsoft.public.sqlserver.dts)
  • Re: Access while running DTS package using stored procedure
    ... The permissions when executing xp_cmdshell can be different depending on who ... which the SQL Server service is running. ... > I wrote a DTS Package that can take the data from a .txt file residing ... > Declare @RunDTS as varchar ...
    (microsoft.public.sqlserver.dts)