topic load csv data to database in Talend Studio

load csv data to database

Anonymous — Wed, 07 Feb 2018 04:20:21 GMT

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?

Re: load csv data to database

manodwhb — Wed, 07 Feb 2018 05:08:53 GMT

Are you using same db to load and which you were verfying?

Re: load csv data to database

Anonymous — Wed, 07 Feb 2018 05:16:04 GMT

Hi, the db table is empty and i wanted to load from csv file to ms sql. The expected result is to have all csv data in my ms sql table (test_2).

Re: load csv data to database

TRF — Wed, 07 Feb 2018 08:47:58 GMT

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.

Re: load csv data to database

Anonymous — Thu, 08 Feb 2018 03:06:52 GMT

Hi TRF,

I ran the workflow again after ticked "Auto Commit" and it showed all NULL data in my MSSQL table.

Re: load csv data to database

TRF — Thu, 08 Feb 2018 20:09:08 GMT

Probably all rows are rejected when you try to insert them.
Connect a tFileOutputDelimited to your tMSSQLOutput component using the reject flow to get the errors.

Re: load csv data to database

TRF — Sat, 10 Feb 2018 16:51:07 GMT

Does this help?

If so please mark this case as solved (Kudos also accepted).