Home Errors ODBC Error while executing lookup sql.

ODBC Error while executing lookup sql.

Written by 
Rate this item
(1 Vote)

Problem description.

The following error was found in the session log.

 

Lookup query is about to be executed.

Database driver event...

FnName: Execute -- [Informatica][ODBC SQL Server Driver]20152

FnName: Execute -- 523 158]

Error in lookup sql statement execute.

 

There were 5 fields read by lookup transformation from MSSQL database. When removed any 3, no errors noticed. When removed only 2, above errors where generated.

Solution.

The failing transformation was removed and created again. No errors noticed.

Read 8643 times

Latest from Administrator