Eric, Once again I appeal to you for help. I am running a DTS package on a text file. The text file is generated each night from a table on a Unisys mainframe in ASCII text and delimited using the ^. The DTS package is set up with max error count at 9999 and batch insert at 1. The table I am importing into has been set up with correct fields and data types assigned. I am also using a trim statement to eliminate blanks/spaces inserted by the mainframe code from all fields, (I have also tried this import without the trim statement and using the bulk insert, sans transfromation). At about the 5,000th record I get the following error in the exception file and is repeated for each 10,000 records there after:Error at Source for Row number 5066. Errors encountered so far in this task: 1.

"Error Source: Microsoft Data Transformation Services Flat File Rowset Provider Error Description:Too many columns found in the current row; non-whitespace characters were found after the last defined column's data. Error Help File:DTSFFile.hlp Error Help Context ID:0"

Any suggestion/insight you might have would be helpful. I am using the beta version of SQL Server 2000 but have been told that the DTS works the same as SQL Server 7.

thanks in advance.

-- Anonymous, September 06, 2000

Answers

James,

Try using a different text editor (a binary or programmer's editor) to view the file so that you can see _all_ the characters.

In my experience, this error is because of some spurious non visible character at the relevant location - just like the error suggests.

Hope this helps,

Eric

-- Anonymous, September 06, 2000