The connection <database connection> specified is ambiguous. The connection name exists in both relational and application connections.
In the Location Information session property for a Lookup transformation, or the Connection Information session property for a Stored Procedure transformation, you specified a database connection name that exists as both a Relational and Application database connection. When the Integration Service runs the session, it cannot determine which connection to use.
This might occur when you specify the database connection name for the transformation in the Designer and then create a session using the mapping. Or, this might occur when you type the connection name in the session property.
In the session properties, select the correct database connection name for the Lookup or Stored Procedure transformation.