SqlBulkCopy Tutorial - Knowledge Base (KB)

postgresql: how to get primary keys of rows inserted with a bulk copy_from?

The goal is this: I have a set of values to go into table ...A..., and a set of values to go into table ...B.... The values going into ...B... reference values in ...A... (via a foreign key), so after inserting the ...A... values I need to know how to ref...

how to bcp out from sybase few columns from a table with many columns? Also can some logic be accommodated while retrieving data?

I have a huge table with 60 + columns in Sybase ASE, I want to bcp out 12 columns. I was checking syntax on ...manuals... but could not find a way to mention column names. ...I would also like to put some logic while retrieving data, like:...convt = case...

SQL Bulk copy (unicode)

i have a problem with bulk load into my database. Server throws error "String or binary data would be truncated", but my data seems to be ok....Im using UTF-16LE data file with XML format file. Thanks for your answers...Here's my format file:...<BCPFORMA...

BULK generate data SQL Server

I need to create fake data into ...fakeData... table that follows this psuedocode:...foreach(t1.id in table1) foreach(t2.id in table2) foreach(t3.id in table3) INSERT INTO fakeData (t1.id, t2.id, t3.id, random(30,80)) ...Where the id is t...

Skip host file column in bcp format file Sybase

I have a csv texte file like this : ...SicID;PorID;FarId;Company;DecadeId;SocName;FarName A1;A2;A3;A4;A5;A6;A7 B1;B2;B3;B4;B5;B6;B7 C1;C2;C3;C4;C5;C6;C7 ...I want to use Bcp Sybase to import this file in my_table but only the SicID, PorID and SocName. So ...

How to properly avoid insert duplicate rows in SQL Server data tables which don't have any PK?

I'm using ...SqlBulkCopy... class in C# to copy data from one SQL Server database to another in a fast way. The databases are in different servers and their datatables don't have any PK, so the process gets more complicated....The problem is that the quer...