Error 10000

[Eyespi20]

I have a DTS job that is pulling in information from EXCEL into a table I created in my SQL 7.0 database.

When I first created the job, it worked fine. The owners of the EXCEL spreadsheet have made some changes to it and when I adjusted the job to accomodate those changes I now get this error message on a text column that I have set as varchar(1000).

The specific error message I receive is "the data source for column 24 (which is in itself weird as there are only 9 columns total in the table) ('comments') is too large for the specified buffer size"

I have had them reduce the number of characters in the column to 255, but still get the same error message.

Can someone point me in the right direction to solve this issue?

Thanks!

Margaret

 

[Eyespi20]

I've changed the buffer size on the properties for this column from 0 to 2, now the job does not error out, but it only pulls in one record.

When I change it back to 0, I get the same error message.

Can anyone help?

Thanks

Margaret