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

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.