Most efficient way to transfer OdbcDataReader to sql server

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

 

[Ken Tucker [MVP]]

Hi,

If you are using vs 2005 take a look at the sqlbulkcopy.

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx

Ken