What will be BCP format for inserting a identity column

bcp
Chayan picture Chayan · Jul 5, 2010 · Viewed 11.3k times · Source

I am facing problem while I am trying to insert data to a table using BCP. The table has a identity column. I am taking input from a text file. Please let me know if there are any good solutions.

Regards, Chayan

Answer

Simon picture Simon · Oct 27, 2011

I needed to do the same thing and my colleague pointed out that you can use the -E switch on BCP to do this.

From the docs...

"-E Specifies that identity value or values in the imported data file are to be used for the identity column. If -E is not given, the identity values for this column in the data file being imported are ignored."

Works a treat, thanks Jan!

Related questions

Export table to file with column headers (column names) using the bcp utility and SQL Server 2008

I have seen a number of hacks to try to get the bcp utility to export column names along with the data. If all I am doing is dumping a table to a text file what is the most straightforward …

Read More
How to export SQL Server 2005 query to CSV

I want to export some SQL Server 2005 data to CSV format (comma-separated with quotes). I can think of a lot of complicated ways to do it, but I want to do it the right way. I've looked at bcp, but …

Read More
How to export data from SQL Server 2005 to MySQL

I've been banging my head against SQL Server 2005 trying to get a lot of data out. I've been given a database with nearly 300 tables in it and I need to turn this into a MySQL database. My first call was …

Read More