Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I tried to load csv data to ms sql based on the training video online, and the flow is worked successfully. However, when I check the destination table, the data is i push from csv to ms sql is not there, but i see no error in talend. Any idea what went wrong on this?
Hi,
Tick the "Auto commit" option on advanced settings for the tMSQQLConnection component or add a new subjob (onSubjobOK) connected to the tFileInputDelimited component with an explicit tMSSQLCommit component.
You may also have a tPostJob subjob with this component.
Are you using same db to load and which you were verfying?
Hi,
Tick the "Auto commit" option on advanced settings for the tMSQQLConnection component or add a new subjob (onSubjobOK) connected to the tFileInputDelimited component with an explicit tMSSQLCommit component.
You may also have a tPostJob subjob with this component.
Hi TRF,
I ran the workflow again after ticked "Auto Commit" and it showed all NULL data in my MSSQL table.
Does this help?
If so please mark this case as solved (Kudos also accepted).