BCP Utility

Changing BCP format file collation

Hi All, I was wondering if it was possible to change the collation of the format file created by the BCP utility from CS to CI, than import the data? The reason I ask this is I want to import the data from one column to another column using a different collation using bulk insert. Thanks.

DTS import/export

Hi, I was wondering if the DTS import/export also recreate the table, the reason I am asking this I want to recreate a database using the Generate SQL Script but change the collation of the columns of the table, then import the data from that database to this new database. If it does recreate the...

How to write Bcp command to insert data in to a table

Hi, I have a file which contains the data 2:23:3#1:2:4#2:3:5 i have to insert the data in to the table in multiple rows from a single file as #--indicates to be inserted in next row : --indicates next column column1 column2 column3 2 23 3 1 2 4 2 3 5 I need to use BCP. Can any one...

BCP and SQL2005 collation issues

I get this error: Error = [Microsoft][SQL Native Client]Unable to resolve column level collations SQLState = 01000, NativeError = 5701 I am using the standar collation that comes with SQL2005

BCP Utility With Additional "INSERT VALUES" Clause

I've nested 23 separate BCP commands into a single BAT file. Each BCP command pulls data from a separate text file and inserts the data into a single table. Here's the kicker, when inspecting the newly inserted rows in the table, I need to be able to associate each row with the BCP command that...

bcp utility in sql server 2005

hi,how to send logins from server to another server using bcp utility.