Page 1 of 1
Sql Server Bulk Load
Posted: Thu Dec 18, 2014 5:56 am
by Nagac
Hi
Is Bulk Load possible for Sql Server in Datastage 9.1 Parallel Jobs?
Posted: Thu Dec 18, 2014 8:36 am
by chulett
Yes.
Posted: Thu Dec 18, 2014 11:01 am
by Nagac
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
Posted: Thu Dec 18, 2014 11:11 am
by chulett
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.
Posted: Thu Dec 18, 2014 11:17 am
by qt_ky
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.