Most efficient way to transfer OdbcDataReader to sql server

  • Thread starter Thread starter Craig Lucas
  • Start date Start date
C

Craig Lucas

I havent seen anyway to transfer the data over to sql server in a graceful
way. I have to generate sql statements dynamically or loop through each
record and call a stored procedure. Is there a more efficient/bulk way of
moving the data?

PS: Assume I cannot use DTS and the ODBC connection must be established
dynamically, meaning I cant create a DSN.
 
Back
Top