I am currently working a package where I am inserting new records to a SQL server table. This table has a primary key that is an identity field. Once that component is done, my job will continue to the next component that will insert some more records into another table. I need the primary key from each of the records I inserted in the previous step to use as a foreign key.
Is there an easy way of getting the Talend tMSSQLOutput component to retrieve this identity field to pass along with the output to the next component?
Thanks for the reply. I tried the tMssqlLastInstertID component, but had some issues getting it configured. If I remember correctly, the component dropdown list you select from wasn't populated with anything so I could get it configured. I'll try again and see if I have better luck.
