Question on MS SQL Server Load stage

JPalatianos · Post by **JPalatianos** » Wed Jun 26, 2013 4:35 am

Hi,
I was just curious if there is a parallel stage that is similar to the server stage "MS SQL Server Load".

Thanks - - John

ray.wurlod · Post by **ray.wurlod** » Wed Jun 26, 2013 4:06 pm

What, one that works on any instance of SQL Server running on UNIX?

I don't believe so.

JPalatianos · Post by **JPalatianos** » Wed Jul 10, 2013 1:47 pm

Thank You..There is no such stage in the Parallel pallete.

ray.wurlod · Post by **ray.wurlod** » Wed Jul 10, 2013 3:56 pm

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.

ArndW · Post by **ArndW** » Wed Jul 10, 2013 11:38 pm

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.

JPalatianos · Post by **JPalatianos** » Wed Aug 27, 2014 9:09 am

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?