That shouldn't be a problem, but I'm not sure if your format file is correct.

Here's one example that I use, it might help you out.

<?xml version="1.0"?>

<BCPFORMAT

xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<RECORD>

<FIELD ID="0" xsi:type="CharTerm" TERMINATOR='"'

MAX_LENGTH="1" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="1" xsi:type="CharTerm" TERMINATOR='","'

MAX_LENGTH="10" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="2" xsi:type="CharTerm" TERMINATOR='","'

MAX_LENGTH="3" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="3" xsi:type="CharTerm" TERMINATOR='","'

MAX_LENGTH="1" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="4" xsi:type="CharTerm" TERMINATOR='",'

MAX_LENGTH="1" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="5" xsi:type="CharTerm" TERMINATOR=','

MAX_LENGTH="9" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="6" xsi:type="CharTerm" TERMINATOR=','

MAX_LENGTH="9" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="7" xsi:type="CharTerm" TERMINATOR=',"'

MAX_LENGTH="9" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="8" xsi:type="CharTerm" TERMINATOR='",'

MAX_LENGTH="26" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="9" xsi:type="CharTerm" TERMINATOR=','

MAX_LENGTH="5" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="10" xsi:type="CharTerm" TERMINATOR=',"'

MAX_LENGTH="5" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="11" xsi:type="CharTerm" TERMINATOR='","'

MAX_LENGTH="4" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="12" xsi:type="CharTerm" TERMINATOR='",'

MAX_LENGTH="8" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

<FIELD ID="13" xsi:type="CharTerm" TERMINATOR="\r"

MAX_LENGTH="5" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>

</RECORD>

<ROW>

<COLUMN SOURCE="1" NAME="DAT_EXCHANGE" xsi:type="SQLCHAR" LENGTH="10"/>

<COLUMN SOURCE="2" NAME="COD_FCC" xsi:type="SQLCHAR" LENGTH="3"/>

<COLUMN SOURCE="3" NAME="FLG_FCCB3" xsi:type="SQLCHAR" LENGTH="1"/>

<COLUMN SOURCE="4" NAME="FLG_QUOTATION" xsi:type="SQLCHAR" LENGTH="1"/>

<COLUMN SOURCE="5" NAME="FIXRATE" xsi:type="SQLDECIMAL" PRECISION="9" SCALE="5"/>

<COLUMN SOURCE="6" NAME="BIDRATE" xsi:type="SQLDECIMAL" PRECISION="9" SCALE="5"/>

<COLUMN SOURCE="7" NAME="OFFERRATE" xsi:type="SQLDECIMAL" PRECISION="9" SCALE="5"/>

<COLUMN SOURCE="9" NAME="ENT_LASTMOD" xsi:type="SQLDECIMAL" PRECISION="4" SCALE="0"/>

<COLUMN SOURCE="10" NAME="BRN_LASTMOD" xsi:type="SQLDECIMAL" PRECISION="4" SCALE="0"/>

<COLUMN SOURCE="11" NAME="LASTMODTRM" xsi:type="SQLCHAR" LENGTH="4"/>

<COLUMN SOURCE="12" NAME="LASTMODUSER" xsi:type="SQLCHAR" LENGTH="8"/>

</ROW>

</BCPFORMAT>