I am having a problem importing data from a RAW datafeed my company receives on a daily basis.

There is a Format file for the RAW file and from the best I can tell, the correct DDL for the table that the file is imported to.

I am in the process of migrating this BCP along with about 80 other ones to Stored Procedures and Batch files.

As of right now, all but one seems to be working ok.

I keep getting the error "Line 1: error near (1001)" when the BCP import takes place.

I have look at the input file and the format file, as well as the Table. I cannot find the problem.

If someone could assist with this, I will be more than happy to e-mail them the files to take a look at (i.e. FMT, DDL, RAW files).

Thanks in advance.