SQL Server Bulk Loader Stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
adamski
Charter Member
Charter Member
Posts: 54
Joined: Thu Mar 20, 2003 5:02 pm

SQL Server Bulk Loader Stage

Post by adamski »

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
Top
Post Reply

Return to “IBM<sup>®</sup> Infosphere DataStage Server Edition”