SqlBulkCopy Tutorial - Knowledge Base (KB)

What is the procedure for importing a 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 use an ODBC connection to conduct a SqlBulkCopy (equivalent) 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...

Windows Service and ODBC

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