SQL Server Bulk Loader Stage
Posted: Wed Dec 05, 2007 10:08 pm
I have searched the forum and cannot find a conclusive answer.
I am attempting to use the SQL Server bulk load stage, however am getting the DataStage error:
"SQL server OLEDB provider authorization failed."
The database log contains:
"12/06/2007 09:36:26,Logon,Unknown,Login failed for user 'xxxxxx'. [CLIENT: 10.8.6.37]
12/06/2007 09:36:26,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5."
10.8.6.37 is our ETL server.
The database is on a separate server.
The DS doco states the stage uses MDAC, however does not state on which server it should be installed, the ETL or database.
The username and password do connect to the database, and according the our DBA there is no reason why we cannot bulk load.
Can anyone shed any light on this?
Thanks
Adamski
I am attempting to use the SQL Server bulk load stage, however am getting the DataStage error:
"SQL server OLEDB provider authorization failed."
The database log contains:
"12/06/2007 09:36:26,Logon,Unknown,Login failed for user 'xxxxxx'. [CLIENT: 10.8.6.37]
12/06/2007 09:36:26,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5."
10.8.6.37 is our ETL server.
The database is on a separate server.
The DS doco states the stage uses MDAC, however does not state on which server it should be installed, the ETL or database.
The username and password do connect to the database, and according the our DBA there is no reason why we cannot bulk load.
Can anyone shed any light on this?
Thanks
Adamski