SqlBulkCopy Tutorial - Knowledge Base (KB)

How do I Import table from an ODBC Database?

I have an ODBC Database (some third party DB) where I have a bunch of tables. I am able to use 'GetSchema' to get a list of tables in there. I am also abe to utilize SQLBulkCopy to copy Data from these tables to SQL Server tables (only when I have created...

How can I perform an SqlBulkCopy (equivalent) using an ODBC connection in C#?

I am working on a project where I need to extract data from a MSSQL database table, and then insert the data into a table of the same structure on an AS400....The SqlBulkCopy would be the ideal candidate for this operation, but fails (understandably) beca...

ODBC and Windows Service

I'm new to windows services and... you guessed it, I’m a bit stuck. Let me paint the picture –...I’m running a timed service that use an OdbcDataReader and SqlBulkCopy to (1) archive the data (2) normalize the data on a SQL box. When I run this code...

Bulk copy (C API) and ODBC driver for SQL Server

I'm trying to use the ODBC bulk copy API with SQL Server: bcp_init, bcp_bind, bcp_sendrow, .... in a C++ program...I don't know what is the latest driver and what I should link against?...I've tried the "SQL Server" driver and linking against odbcbcp.lib....