Transformation <source or target instance name> uses connection variable <connection variable name>, but its value is not specified.
The source or target connection name is specified using the connection variable $Source or $Target. The value of the connection variable is not defined and the Integration Service cannot determine which database connection to use when it runs the session.
Enter a value for the $Source or $Target connection variable on the General Options settings of the Properties tab in the session properties.