Casting error prevents data from being imported (using DTS) 1

[mitchsrf]

Hello,

I've implemented a DTS job that imports data from a Microsoft Access database (via ODBC) into SQL server 7.0.

The Access DB has about 51,000 records. At row 36,899 the importing stops and an error message says there's a casting error. The row did not contain any odd data, it was similar to the 36,000 previous records that were successfully imported. As an experiment, the record was deleted and when DTS was ran again, the same casting error was prompted - now for the record immedietly above the one just deleted (36898).

It seems like the error is not a 'casting' problem but something else like limited db size (although no limit is set and I also increased the size of the db).

Thanks.

 

[foxdev]

The biggest casting error I can think of was Dustin Hoffman as a gangster.

My guess is that there is some stray character in the data that is throwing off the columns. Could there be some data that contains embedded single quote (') marks?

Try modifying the DTS job to allow, say, 100 errors, and write the errors out to a file. When/if it bombs, open up the error output file and see if you can detect anything askew with the data. Robert Bradley
Support operation moo!
Visit the OpCow page

http://www.agrainofhope.org/opcow.shtml

to help in this cause