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
MS SQL Server load error
Moderators: chulett, rschirm, roy
MS SQL Server load error
Last edited by gomez on Fri Nov 03, 2006 6:39 pm, edited 1 time in total.
-
- Participant
- Posts: 5
- Joined: Fri Jun 03, 2005 9:08 am
Try hardcoding the properties.Dont use DSNgomez 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?
Server Name: XXXX (Physical Server Name)
Database Name:XXXX (DB name on the server)
user Name:XXXXX
Password:XXXXX