When a communication failure occurs while the Integration Service is executing a script for an input row, the Integration Service tries to re-connect to the database.
Use the following rules and guidelines for resiliency in script mode:
If the Integration Service fails to connect to the database, and the connection is static, the session fails. If the SQL transformation is using a dynamic connection, the session continues.
If the Integration Service re-connects to the database, it skips processing the current row and continues to the next row.