need to add one row with out input

Six Stars

need to add one row with out input

I need insert a row into MS SqlServer DB Table how can i do it
Raghunath Lingutla
One Star

Re: need to add one row with out input

Hello,
A bit more information would be nice (what kind of row for example), but perhaps this allready answers your question:
There are several ways to add data to your database.
a. Just add tMSSQLRow to the canvas and insert the query to add your row
but you probably want some specific data inserted in your database. For example a CSV file (but could be anything)
b. add 2 components (tMSSQLOutput and tFileInputDelimited), setup the schema of the table. If the schema from the file does not match the database table you could consider fixing this with tMap.
I hope you can progress with this information

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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch