FIX: Event Log and DTS Error File does not Show DTS Error Detail

Article translations Article translations
Article ID: 247891 - View products that this article applies to.
This article was previously published under Q247891
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 56355 (SQLBUG_70)
Expand all | Collapse all

On This Page

SYMPTOMS

When a DTS package step fails, the Error file and Windows NT Event log does not provide any information on why the step failed, even though the DTS Wizard and Designer UI displays the full error in a message box.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0
For more information, contact your primary support provider.

MORE INFORMATION

Steps to Reproduce the Problem

  1. Create a table with a primary key in SQL database and import from a text file with a duplicate key. Run the following script in SQL Query Analyzer:
    CREATE TABLE DTS_Text
    ( Id INT NOT NULL PRIMARY KEY,
      Name CHAR(10) NOT NULL )
    go
    					
  2. Create a text file with the following data:
     1, "One"
     2, "Two"
     3, "Three"
     1, "Fail"
    						
  3. Create a Package with the DTS Import Wizard, point to the text file data source and SQLOLEDB as the destination. Select the table you created earlier. Save the package in SQL Server. When you execute the package, you will see an error message similar to the following:
    Error at Destination for Row number 4. Errors encountered so far in this task: 1.
    The statement has been terminated.
    Violation of primary key constraint 'PK__DTS_Text__090A5324'. Cannot insert duplicate key in object 'DTS_Text'.
  4. Open the package in DTS Designer in SQL Enterprise Manager. Edit package properties and specify an Error file and also enable the option write completion status to event log.

    Execute the package and you receive the detailed error in DTS Designer. However, the Error file will contain the following line without any detail:
    Step 'Copy Data from TextData to [pubs].[dbo].[DTS_Text] Step' failed.
    						
    The Windows NT Application Event log will also have the same message without any details.

Properties

Article ID: 247891 - Last Review: October 22, 2013 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfaq kbfix KB247891

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com