You try to execute a complex SQL statement in a Microsoft Host Integration Server 2010 environment. When the SQL statement contains a question mark ('?') literal, Microsoft OLE DB Provider for DB2 may fail.
For example, you create a new Microsoft SQL Server Integration Service (SSIS) package, and you insert a Data Flow package. You create an OLE DB source, and you insert an SQL statement that contains a '?' literal as in the following example:
In this scenario, when you close the dialog box, a red bullet is displayed. Additionally, in the Errors pane, you receive the following error message:
For example, you create a new Microsoft SQL Server Integration Service (SSIS) package, and you insert a Data Flow package. You create an OLE DB source, and you insert an SQL statement that contains a '?' literal as in the following example:
SELECT NDECRE || '?'
FROM TIGS981
FETCH FIRST 10 ROWS ONLYIn this scenario, when you close the dialog box, a red bullet is displayed. Additionally, in the Errors pane, you receive the following error message:
Validation error.
Data Flow Task: The SQL command requires 1 parameters, but the parameter mapping only has 0 parameters.
Data Flow Task: The SQL command requires 1 parameters, but the parameter mapping only has 0 parameters.