I have a bulk insert I designed that works fine for our SQL 2000 server. However when I try to run it on a SQL 7 Server, I get the error: "Could not bulk insert. Invalid column number in format file"

The only thing I changed in the format file is the 8.0 to a 7.0.

Some columns in the format file do not go to a column in the database, but I didn't see that being a problem. Here is the format file:

7.0 5 1 SQLCHAR 0 12 "\"," 0 ID "" 2 SQLCHAR 0 5 ",\"" 0 data_year "" 3 SQLCHAR 0 64 "\",\"" 2 design_center SQL_Latin1_General_CP1_CI_AS 4 SQLCHAR 0 5 "\"," 0 data_month "" 5 SQLCHAR 0 7 "\r\n" 3 ds1_count ""

Any ideas? Thanks!

-- Mike Kriz (mk7578@sbc.com), May 13, 2002