Sql Server Bulk Load

Nagac · Post by **Nagac** » Thu Dec 18, 2014 5:56 am

Hi

Is Bulk Load possible for Sql Server in Datastage 9.1 Parallel Jobs?

chulett · Post by **chulett** » Thu Dec 18, 2014 8:36 am

Nagac · Post by **Nagac** » Thu Dec 18, 2014 11:01 am

Thanks Craig,

Can you please advise where we achieve this functionality? I mean which stage and Options.

Currently I am using ODBC Stage and I couldn't find the Option.

Thanks

chulett · Post by **chulett** » Thu Dec 18, 2014 11:11 am

Not possible with ODBC as far as I know. Since you are on a Windows server, you should have some 'extra' stages specific to SQL Server and those would be the ones to use. From memory, an OLEDB and perhaps even a specific SQL Server Bulk Load stage? Searches here should turn up discussions on the topic.

qt_ky · Post by **qt_ky** » Thu Dec 18, 2014 11:17 am

In 8.x and other versions you can use the ODBC Connector stage along with one of the newer, bundled Progress DataDirect ODBC drivers for SQL Server, or so I've been told. The older ODBC driver does not support bulk loads.