https://community.qlik.com/t5/Talend-Studio/need-to-add-one-row-with-out-input/m-p/2352745#M119083 Hello, <BR />A bit more information would be nice (what kind of row for example), but perhaps this allready answers your question: <BR />There are several ways to add data to your database. <BR />a. Just add tMSSQLRow to the canvas and insert the query to add your row <BR />but you probably want some specific data inserted in your database. For example a CSV file (but could be anything) <BR />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. <BR />I hope you can progress with this information Fri, 23 Dec 2011 08:45:17 GMT Anonymous 2011-12-23T08:45:17Z https://community.qlik.com/t5/Talend-Studio/need-to-add-one-row-with-out-input/m-p/2352744#M119082 I need insert a row into MS SqlServer DB Table how can i do it Sat, 16 Nov 2024 12:29:29 GMT https://community.qlik.com/t5/Talend-Studio/need-to-add-one-row-with-out-input/m-p/2352744#M119082 Raghunath 2024-11-16T12:29:29Z https://community.qlik.com/t5/Talend-Studio/need-to-add-one-row-with-out-input/m-p/2352745#M119083 Hello, <BR />A bit more information would be nice (what kind of row for example), but perhaps this allready answers your question: <BR />There are several ways to add data to your database. <BR />a. Just add tMSSQLRow to the canvas and insert the query to add your row <BR />but you probably want some specific data inserted in your database. For example a CSV file (but could be anything) <BR />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. <BR />I hope you can progress with this information Fri, 23 Dec 2011 08:45:17 GMT https://community.qlik.com/t5/Talend-Studio/need-to-add-one-row-with-out-input/m-p/2352745#M119083 Anonymous 2011-12-23T08:45:17Z