Use the following rules and guidelines when you configure the SQL transformation to process a query:
The number and the order of the output fields must match the number and order of the fields in the query SELECT clause.
The native data type of an output field in the transformation must match the data type of the corresponding column in the database.
generates a row error when the data types do not match.
When the SQL query contains an INSERT, UPDATE, or DELETE clause, the transformation returns data to the SQLError field, the pass-through fields, and the NumRowsAffected field when it is enabled. If you add output fields, the fields receive NULL data values.
When the SQL query contains a SELECT statement and the transformation has a pass-through field, the transformation returns data to the pass-through field whether or not the query returns database data. The SQL transformation returns a row with NULL data in the output fields.
When the number of output fields is more than the number of columns in the SELECT clause, the extra fields receive a NULL value.
When the number of output fields is less than the number of columns in the SELECT clause,
generates a row error.
You can use string substitution instead of parameter binding in a query. However, the input fields must be string data types.