DSXchange

Hi
I am trying to use MS Bulk Load stage to load 6 million plus records from a sequential file. Underlying database is SQL Server 2000 on a different server machine than the DataStage Server.
I have created a DSN with SQL server driver and passed it to the properties
I get the following error
Internal error: IDBInitialize->Initialize() failed.
Please help
Thanks

I tested the DSN connection to the SQL server database using odbcping and it connected successfully. So there is no problem with the DSN configuration.
Any pointers please?

gomez wrote:I tested the DSN connection to the SQL server database using odbcping and it connected successfully. So there is no problem with the DSN configuration.
Any pointers please?

Try hardcoding the properties.Dont use DSN
Server Name: XXXX (Physical Server Name)
Database Name:XXXX (DB name on the server)
user Name:XXXXX
Password:XXXXX

Thanks Satyakunta
I tried the same. It works. Thanks for the help

Another observation on this. I had to provide A SQL Server Authentication in order to make MS SQL Server Bulk Load work. Windows NT Authentication credentials did not work with this stage