I created a table with 43 columns. The table contains char, varchar, and tinyint datatypes. I am running on Windows Server 2008 R2 64bit.

The file contains two rows and is comma separated. The file is BCP output from MSSQL.

When I tried to bulk load into the table from a file with a COPY INTO command I got an unhelpful message.

"failed to import table"

How can I find out why the import failed?