BCP Import Errors

I'm using a credit union software/database package (Symitar/Episys) to export the data tables for use with MS SQL 7.0. After I move the files onto my SQL Server 2000 box and then run the import batch file (there are 40 some odd tables to move) which has the correct destination table, import file and format file listed. While the batch is running in a command window, I spy three specific errors during the process. they are:

String Data, Right Truncation (I added spaces/changed to larger data type to the tables to possibly mitigate this to no avail)

Invalid Character Data For Cast Specification

Invalid Date Format (all my dates in the export file are in the format xxxx-xx-xx)

I have spent several hours on researching them and trying some of the fixes to no avail

The first export was a comma delimited file and had many errors, I then switched to a tab delimited export and changed the command line in the batch file to reflect that fact. I have fewer errors with the tab version but still have errors. I have tried to view the data in the export files at the probable location but can't see anything that will cause these errors.

Here are three lines in the batch file that I'm using:

bcp ACUTest..NAME in c:\DataXfer\EXTRACT.NAME -fc:\DataXfer\FMT.NAME -t \t -Satlas -Usa -Pwhatever -V70

bcp ACUTest..COMMENT in c:\DataXfer\EXTRACT.COMMENT -fc:\DataXfer\FMT.COMMENT -t \t -Satlas -Usa -Pwhatever -V70

bcp ACUTest..SAVINGSNAME in c:\DataXfer\EXTRACT.SAVINGSNAME -fc:\DataXfer\FMT.SAVINGSNAME -t \t -Satlas -Usa -Pwhatever -V70

If I've been to vague anywhere please let me know so I can provide more info.

Thank you all for your insight and valuable time.

Seems that you have the same problem like this poster here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=908084&SiteID=1

Did you checked the data types of the destination table ?

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de