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
1 REPLY
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