https://community.qlik.com/t5/Talend-Studio/resolved-Updating-staging-table-After-successful-database/m-p/2206378#M6460 Hi Siddharth, <BR />You can add one more output and connect it to your stored procedure. <BR />Vaibhav Thu, 18 Dec 2014 10:28:36 GMT Anonymous 2014-12-18T10:28:36Z https://community.qlik.com/t5/Talend-Studio/resolved-Updating-staging-table-After-successful-database/m-p/2206377#M6459 Hi <BR />I am new to Talend and was hoping someone could provide me a solution for the following <BR />To process my data - i first load the data into a staging table which has a status column, error message column. The intention here is to record the status of the data operation and log the error message. <BR />My question is that after the database operation completes - i have success records and rejects and i need to according update the staging table via a stored procedure. However how do i pass the primary key of the staging table to the stored procedure task from the main database insert task. The main table has no idea about the staging or its schema. <BR />The screen shot below might make it more clear. <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MBbN.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144864i4C68C14279B960E1/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MBbN.png" alt="0683p000009MBbN.png" /></span> Tue, 16 Dec 2014 14:52:11 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Updating-staging-table-After-successful-database/m-p/2206377#M6459 Anonymous 2014-12-16T14:52:11Z https://community.qlik.com/t5/Talend-Studio/resolved-Updating-staging-table-After-successful-database/m-p/2206378#M6460 Hi Siddharth, <BR />You can add one more output and connect it to your stored procedure. <BR />Vaibhav Thu, 18 Dec 2014 10:28:36 GMT https://community.qlik.com/t5/Talend-Studio/resolved-Updating-staging-table-After-successful-database/m-p/2206378#M6460 Anonymous 2014-12-18T10:28:36Z