Hi
Is Bulk Load possible for Sql Server in Datastage 9.1 Parallel Jobs?
Sql Server Bulk Load
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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.
Choose a job you love, and you will never have to work a day in your life. - Confucius