If tMSSqlOutput uses an existing connection from the tMSSqlConnection component, it will not create anything in SQL

Symptoms

If tMSSqlOutput uses the existing connection from the tMSSqlConnection component, it will not create anything in SQL. However, if it does not use the existing connection and builds from the same repository as tMSSqlConnection, tMSSqlOutput works as intended and creates the SQL Table upon execution. Additionally, it does not throw any errors during the run, but fails to create/insert any tables/data.

Diagnosis

With an existing connection selected:

Without an existing connection:

Solution

Verify that Auto Commit is selected under Advanced Settings of the tMSSqlConnection, or you can add a tMSSqlCommit component.