Page 1 of 1
Question on MS SQL Server Load stage
Posted: Wed Jun 26, 2013 4:35 am
by JPalatianos
Hi,
I was just curious if there is a parallel stage that is similar to the server stage "MS SQL Server Load".
Thanks - - John
Posted: Wed Jun 26, 2013 4:06 pm
by ray.wurlod
What, one that works on any instance of SQL Server running on UNIX?
I don't believe so.
Posted: Wed Jul 10, 2013 1:47 pm
by JPalatianos
Thank You..There is no such stage in the Parallel pallete.
Posted: Wed Jul 10, 2013 3:56 pm
by ray.wurlod
Does not the SQL Server Connector stage have a "bulk load" capability?
This stage type only exists if DataStage engine runs on Windows Server; otherwise you can use the ODBC Connector, but it does not have a bulk load capability.
Posted: Wed Jul 10, 2013 11:38 pm
by ArndW
Actually the Connector does have bulk load capability - if you enable "bulk load" in the ODBC driver definition. I'm using that capability right now (literally, since we are loading our data warehouse with the initial data contents as I write this) and the performance gain compared to the normal insert mode is very significant, two orders of magnitude.
Posted: Wed Aug 27, 2014 9:09 am
by JPalatianos
I enabled "bulk load" in the SQL SERVER ODBC driver definition and my question is what stage are you using that is enabiling you to bulk load into SQL server. Is there a check box?