Use DRS stage to do bulk insert to MSSQL
Posted: Fri Aug 21, 2009 3:06 pm
I have a job that inserts rows into a table in a sql server database. I set up a DRS stage with "Truncate table then insert rows" for the "update action". I set the array size to 15000 and the transaction size to 50000.
I found out from the sql server DBA that it was inserting one row at a time. It took 55 minutes to load 7 million rows. The suggestion was to do a bulk insert to speed up the load.
When I selected "Bulk insert" from the drop down for "update action", I got the following fatal error:
Stage supports bulk load to sql server only on windows
Does this mean that a patch is required, or there is something wrong with my settings?
We or on a solaris platofrm.
Thanks
I found out from the sql server DBA that it was inserting one row at a time. It took 55 minutes to load 7 million rows. The suggestion was to do a bulk insert to speed up the load.
When I selected "Bulk insert" from the drop down for "update action", I got the following fatal error:
Stage supports bulk load to sql server only on windows
Does this mean that a patch is required, or there is something wrong with my settings?
We or on a solaris platofrm.
Thanks