An error occurred expanding a parameter or variable in the environment SQL <connection or transaction environment SQL> for the connection object <connection name>.
The SQL transformation is using a connection object that is configured with connection or transaction SQL. The SQL contains a parameter or variable that the Integration Service cannot resolve.
Verify that the parameter or variable is defined properly in the parameter file and that its value in the parameter file matches the parameter or variable datatype. For example, you cannot set an integer mapping variable to a text string in the parameter file.