I want to perform bulk load on sql server databse but i am using ODBC connection to sql server.
I tried to do bulk insert using DRS connector stage but it seems that it is inserting throgh normal load.I got below entry in log.
Code: Select all
Generated INSERT statement: INSERT INTO AIT_Staging.dbo.SRE_CORRECTED_SALES(column list)
VALUES (ORCHESTRATE column list)
The DRS Connector stage does not support bulk load operation to Microsoft SQL Server databases. Note however that the Microsoft SQL Server ODBC wire driver included with InfoSphere Information Server supports bulk load mode for writing data to the database. Therefore DRS Connector can be used to perform bulk load to Microsoft SQL Server by following these steps:
1.Configure DRS Connector stage to use ODBC database type.
2.Define ODBC data source name (DSN) based on the Microsoft SQL Server wire driver.
3.Customize the DSN definition to enable the bulk load mode of operation.
My question is what parameters reqired to perform bulk load in ODBC DSN.