Re: DTS Error Messages

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 05/11/04 

Date: Tue, 11 May 2004 07:53:57 +0100

The "Nice" error message should still be there. The package level logging
can be seen sometines as a summary but for a DataPump task it has it's own
logging ability and is pretty good. 

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Gary" <anonymous@discussions.microsoft.com> wrote in message
news:afa201c43721$0927aca0$a401280a@phx.gbl...
> Hi All
>
> When I execute a DTS Package interactively I can view the
> Status of each step through the Execution Progress screen
> that contains the execution progress status bar.  ie.
> Step 1 - Complete; Step 2 - Not Run; Step 3 - Error
> Occurred etc.  When I click on a step that has failed I
> receive an "nice" error message.  How do I go about
> capturing this error message that is displayed when the
> status is clicked on so that the error message can be
> written to a file when the package is executed as a Job
> Step.  I have tried logging the package using the error
> log but the error displayed in the log file does not
> contain the "nice" message that is displayed when the
> step status is selected interactively.  Any assistance
> would be appreciated.
>
> Thanks
>

Relevant Pages

  • DTS Error Messages
    ... When I execute a DTS Package interactively I can view the ... Status of each step through the Execution Progress screen ... capturing this error message that is displayed when the ... log but the error displayed in the log file does not ...
    (microsoft.public.sqlserver.dts)
  • Re: ORA-03117 resulting from package procedure parameter record types
    ... I am at a client who has recently migrated from Oracle 7.3.4 to Oracle ... number of the package procedures, ... procedure proc1 is ... bind variables fails with the oracle error message "ORA-03117: ...
    (comp.databases.oracle.misc)
  • Re: Package Load Failure
    ... > After some days working fine, I am getting an error message when I try to ... > load my device application project. ... > "Package Load Failure ... > Package 'Smart Device Project Package' has failed to load properly (GUID ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Thoughts about finding viruses in email inboxes
    ... The key I used was the one from the error message. ... I would expect the gpg key for package verification to ... The problem was/is being able to authenticate the d/l server. ...
    (Ubuntu)
  • Re: Thoughts about finding viruses in email inboxes
    ... The key I used was the one from the error message. ... I would expect the gpg key for package verification to ... The problem was/is being able to authenticate the d/l server. ...
    (Ubuntu)