DataDirect Driver for Microsoft SQL Server
Effective in version 9.5.1, a session with a Microsoft SQL Server source can fail when the number of columns in the SELECT statement in the query is less than the number of ports in the Source Qualifier transformation. The session fails with the following error:
SQL Error [FnName: Fetch Optimize -- [Informatica][ODBC SQL Server Wire Protocol driver] Number of bound columns exceeds the number of result columns.].
Previously, the same session succeeded when the number of result ports in the SQL query did not match the number of ports in the Source Qualifier transformation.