Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Raghunath
Creator
Creator

need to add one row with out input

I need insert a row into MS SqlServer DB Table how can i do it
Labels (2)
1 Reply
Anonymous
Not applicable

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