AseBulkCopy not available in list of commands

bcp command execution incoherence

You might take a look at the following article and play with the switches in you BCP statement....Copying Data Between Different Collations

How do I convert a generic list to a DataReader in.NET?

If the data-volume is sane enough to exist as a ...List<T>..., you might as well just construct a ...DataTable... and push the data in that way. I don't ...like...DataTable..., but it does this job nicely. The alternative would be to write a custom ...IDataReader... implementation ...like this..., but which iterates over the items in the list each ...

Is there a BulkUpdate command in SQL Server 2008 that is equivalent to BulkCopy?

Disclaimer...: I'm the owner of the project ...Bulk Operations...The Bulk Operations Library allow to Insert, Delete, Update and Merge millions of rows in few seconds....It's very easy to learn and use if you already know the SqlBulkCopy class....var bulk = new BulkOperation(connection); // ... Mappings .... bulk.BulkUpdate(dt);

How to debug Postgres copy command failure

I always seem to get a line-number in my error, no matter whether I use ...COPY... or ...\copy... and feed a file via redirection or ...-f.......ERROR: invalid byte sequence for encoding "UTF8": 0xa3 CONTEXT: COPY z, line 3 ...If there are only a couple of bad chars and you just want to strip them you can use iconv (assuming you're on a unix-like...

Get the count of rows from a COPY command

Not in PG 9.2, but there is in PG 9.3 courtesy of Pavel (E 1.3.1.7):...Allow PL/pgSQL to access the number of rows processed by COPY (Pavel Stehule)...The command is GET DIAGNOSTICS x = ROW_COUNT....http://www.postgresql.org/docs/devel/static/release-9-3.html

Replaying SQL Server Trace for SqlBulkCopy Command

Unfortunately, you can't replay bulk loads:... Traces that contain operations on text, ntext, and image columns involving the bcp utility, the BULK INSERT, READTEXT, WRITETEXT, and UPDATETEXT statements, and full-text operations. These events are skipped.

bcp command is replacing empty strings with nulls

The best way is to leave null value not empty string on database. Then BCP will export empty string into file (.csv, .txt or so). ...Please refer to ...BCP MSDN...: ...out copies from the database table or view to a file. If you specify an existing file, the file is overwritten. ...When extracting data, note that the bcp utility represents an emp...

C# transaction error in AseBulkCopy

CREATE TABLE... generated by ...sp_oledb_columns... procedure, called during bulk copy operation preparation steps....So as RobV said, you need to allow DDL to tempdb (execute from ...master... db):...sp_dboption tempdb, 'ddl in tran', 'true'

Fastest way to create DataTable from List without for loop

The fastest way would be: not to....SqlBulkCopy... can take an ...IDataReader.... "FastMember" (on NuGet) can expose a ...List<T>... as an ...IDataReader...:...List<ObjectDo> listDos = ... using(var bcp = new SqlBulkCopy(connection)) using(var reader = ObjectReader.Create(listDos, "Id", "FkId", "Status", "RecordFrom")) { bcp.DestinationTab...

How To Convert List Into DataTable For SQlBulkCopy

A better option is to use ...FastMember's... ObjectReader to create an IDataReader on top of the collection or IEnumerable. This way you avoid doubling memory usage by copying everything into a DataTable....From the repo's samples: ...using(var bcp = new SqlBulkCopy(connection)) using(var reader = ObjectReader.Create(myList, "Id", "Name", "Descrip...