SQL SERVER 2000 - DTS package Error without Error Source and Decription.

• mariana5211

  SSC Rookie

  Points: 43

  More actions

  February 28, 2011 at 11:55 pm

  #231947

  Hi, I am using SQL Server 2000 DTS package to import data from csv file (source) to SQL server database (destination).

  The data source has 514 columns and the max row size is more than 13000, which actually exceeds the row size limitation (8060). There are more than 350,000 records in the source.

  I use DTS to create the table in SQL server with success. I set up the Max Error Count as 1000 when configuring the Transform Data Task. The Data Transfor Task compledted with "sucess" (after click 'Execute Step' and wait for a couple of mins, a pop up window says...). However, actually there are NO records got inserted into the destination table. The log file is like the below:

  ==============================================

  ...........

  .........

  Error at Source for Row number 325039. Errors encountered so far in this task: 27.

  Error Source: Microsoft Data Transformation Services Flat File Rowset Provider

  Error Description:Column Delimiter not found.

  Error Help File:DTSFFile.hlp

  Error Help Context ID:0

  Error at Source for Row number 326492. Errors encountered so far in this task: 28.

  Error Source: Microsoft Data Transformation Services Flat File Rowset Provider

  Error Description:Column Delimiter not found.

  Error Help File:DTSFFile.hlp

  Error Help Context ID:0

  Error at Destination for Row number 354843. Errors encountered so far in this task: 29.

  Execution Completed: 3/1/2011 2:19:05 PM

  =========================================================

  It only throw 29 errors. The first 28 suggests the 'Column Delimiter not found' on particular rows of the source file. The last log is strange since it suggest some error happened on DESTINATION at the LAST row, however there are no Error Source and Error Description populated.

  Later on, I specify only import the row 1 to 100,000 (and also tried a couple of other numbers) to the destination, however the same error thrown likely, on Destination, at last row, no error source and description.

  I further specify only import the row 1 to 30,000 to the destination and the task does succeed....

  Then, I specify only import the row 1 to 25000 to the destination and the error happened again.....

  I am totoally lost and cannot figure out what's the root cause. Has anyone experienced the similar problem? We have a urgent requst to import a million rows to SQL server. Please help.