Create table if does not exist

[Sam_10000]

Hi,

I am total newbie to Talend and trying it out.

I built a simple test job that reads from MSSql and writes data to a file. Now I tried the tMSSqlOutput component to get my results into a table. I have set the connection in tDBConnection.

I have now tried "Create table" and "Create table is does not exist". Schema is showing all my columns. When I run the job, it goes fine and show rows going into both targets (file & db). When I go to look in MSSql the table is not there.

No errors anywhere.

There must ne something simple that I am missing so can someone point me in the right direction... 🙂

Using TOS 7.3.1

Br,

Sam

[manodwhb]

@Sami Laitio​ , Have you committed the data ? using tDBcommit?

Thanks,

Manohar

[Sam_10000]

Thanks, that did it.

I have been using other ETL tools for 20+ years and having to do a commit separately is new thing.

Br,

Sam

[madhukolli2003]

Hi @Sami Laitio​ ,

You can create table using tDBOutput component .

Under Basic View -->

Table -->Provide table name

Action On Table --> Choose appropriate based on your requirement

You can use tDB commit component or you can enable Auto commit in the TDBConnection (Advanced Settings).

Also, refer to standard document for this option functionality .

Thanks & Regards,

Madhu Kolli