Thursday, April 28, 2011

MS-SQL Bulk Insert w/ RODBC

Is it possible to perform a bulk insert into an MS-SQL Server (2000, 2005, 2008) using the RODBC package?

I know that I can do this using freebcp, but I curious if the RODBC package implements this portion of the Microsoft SQL API and if not, how difficult it would be to implement it.

-- Dan

From stackoverflow
  • You're probably wanting ?sqlSave

    ephpostfacto : Nah, sqlSave will do multiple INSERTS. I want a BULK INSERT which is a single transaction.
    Tyler : does fast=true not do it as a single transaction?

0 comments:

Post a Comment