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:

 

no_table.png

 

Without an existing connection:

 

2017-10-20_13-12-57.png

 

 

Solution

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

 

autocommit.png

Version history
Revision #:
2 of 2
Last update:
‎10-24-2017 01:43 PM
Updated by: