Bulk inserts into SQL Server

Anyone used Ruby w/in a Rails app. to set up a bulk import file for MS
SQL Server?

I have to be able to insert up to ~50000 records into a table and
ActiveRecord one-at-a-time ain’t gonna cut it :).

I’m open, of course, to other, more Rails-y solutions, but plan to go
down the path of generating the appropriate bulk import file format from
my data.

Any advice/information is appreciated.


ActiveRecordExtensions (http://www.continuousthinking.com/ARE/import) is
a plugin that among other things does that. It only caters for mysql
currently, but you might find that it easy to enhance or at least give
you an idea on sensible strategies.