Fail to link Commit with table

[Anonymous]

Hi,I have a question regarding commit with table.

I add a component called tdbCommit and try to link it with my source table "patientRecord" with OnSubjobOK

But it seem cannot link together.

Can anyone explain to me or teach me the solution. Appreciate it.

This is using Microsoft SQL Server

[manodwhb · Accepted solution]

@jhau6 , use on component ok from tDBOutput and connect to tDBcommit.

[Prakhar1]

You don't to use commit component where you transaction is getting completed, not on the starting.

You can also use AutoCommit in the tDBconnection's advance property and can remove the tDBCommit component.