load csv data to database

Four Stars

load csv data to database

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?

 

Capture.PNG2.PNG3.PNG


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

Re: load csv data to database

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.


TRF

All Replies
Forteen Stars

Re: load csv data to database

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

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Four Stars

Re: load csv data to database

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).
Fifteen Stars TRF
Fifteen Stars

Re: load csv data to database

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.


TRF
Highlighted
Four Stars

Re: load csv data to database

Hi TRF,

 

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

Fifteen Stars TRF
Fifteen Stars

Re: load csv data to database

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.

TRF
Fifteen Stars TRF
Fifteen Stars

Re: load csv data to database

Does this help?

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


TRF

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads