BCP Format file issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

BCP Format file issue

Author

Topic

eliewadi
Starting Member

20 Posts

Posted - 2009-02-25 : 13:22:42

Hi I am trying to load a table using BCP but i am getting the following error:

[Microsoft][ODBC SQL Server Driver]Attempt to read unknown version of BCP format file

Any ideas on how to solve this issue?

The database in SQL Server 2005

Here is my BCP format file:

<?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="1" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="10" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="2" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="6" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="3" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="24"/>
<FIELD ID="4" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="24"/>
<FIELD ID="5" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="24"/>
<FIELD ID="6" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="24"/>
<FIELD ID="7" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="2" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="8" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="12"/>
<FIELD ID="9" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="3" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="10" xsi:type="CharTerm" TERMINATOR="," MAX_LENGTH="18" 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="20" COLLATION="SQL_Latin1_General_CP1_CI_AS"/>
<FIELD ID="13" xsi:type="CharTerm" TERMINATOR="\r\n" MAX_LENGTH="24"/>
</RECORD>
<ROW>
<COLUMN SOURCE="1" NAME="Order_Number" xsi:type="SQLVARYCHAR"/>
<COLUMN SOURCE="2" NAME="Order_Line_Number" xsi:type="SQLVARYCHAR"/>
<COLUMN SOURCE="3" NAME="Cust_Req_Date" xsi:type="SQLDATETIME"/>
<COLUMN SOURCE="4" NAME="First_Comm_Date" xsi:type="SQLDATETIME"/>
<COLUMN SOURCE="5" NAME="Req_Due_Date" xsi:type="SQLDATETIME"/>
<COLUMN SOURCE="6" NAME="Committed_Due_Date" xsi:type="SQLDATETIME"/>
<COLUMN SOURCE="7" NAME="Delivery_Priority" xsi:type="SQLVARYCHAR"/>
<COLUMN SOURCE="8" NAME="Demand_Qty" xsi:type="SQLINT"/>
<COLUMN SOURCE="9" NAME="Improve" xsi:type="SQLVARYCHAR"/>
<COLUMN SOURCE="10" NAME="Material_Number" xsi:type="SQLVARYCHAR"/>
<COLUMN SOURCE="11" NAME="Delivery_Plant" xsi:type="SQLVARYCHAR"/>
<COLUMN SOURCE="12" NAME="Modified_By" xsi:type="SQLVARYCHAR"/>
<COLUMN SOURCE="13" NAME="Modified_DateTime" xsi:type="SQLDATETIM4"/>
</ROW>
</BCPFORMAT>

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-02-25 : 13:41:47

http://technet.microsoft.com/en-us/library/cc917593.aspx
says
The header line in the bcp format file was not version 4.2, 6.0, or 7.0.

http://forums.sqlwire.com/showthread.php?t=22141

eliewadi
Starting Member

20 Posts

Posted - 2009-02-25 : 13:51:31

This is an XML file so I don't think u can add the version line

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-02-25 : 14:00:48

does it have .xml extension?

eliewadi
Starting Member

20 Posts

Posted - 2009-02-25 : 14:12:41

Yes it has .xml extensions

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2009-02-26 : 13:56:40

bcp version difference? are you calling the bcp command in your SSIS package if so how? can you use something other than bcp...

eliewadi
Starting Member

20 Posts

Posted - 2009-02-26 : 17:01:09

This has been solved. It was a conflict with a SQL 2000 instance that was installed on the machine. Renaming the SQL 2000 version of BCP resolved the issue

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources