SqlBulkCopy Tutorial - Knowledge Base (KB)

sybase bulk copy

I need to selectively (both rows and columns) export around 20 million rows from one table to another. This is what I tried:...--Run this in batch: INSERT INTO Table 2 Select A, B from Table1 where A > a and B < b ---Table1 have columns A, B....Z and go...

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 ...

AseBulkCopy not available in list of commands

I am trying to bulk insert records in Sybase using C#. I have included ...Sybase.Data.AseClient.dll... in my solution and able to create connection....But problem is there is no ...AseBulkCopy... command available as shown in screenshot below. What could ...

C# transaction error in AseBulkCopy

I have a program that is performing a bulk copy into a few Sybase db tables. However, the rollback transaction isn't working. When stepping through the logic, the issue seems to be with the transaction object. I'm at a loss right now. Any advice would be...