my main issue is why i lose 'main' data flow if i pass throught OnComponenetOK and why i don't get last id inserted in a database table unless i pass throught that trigger OnComponenetOK or some trigger that lets the job pass some time period ; why can't i directly get the value of the last id inserted so that at least i can keep my 'main' flow data and add the new id to it and do what i want :
so if i use lastidINSERTED i lose data and i get the id : in this case i must use a trigger connection!
but if i use 'main'
connection
, i keep the data flow ; but i get a delayed last ID (first line i get 0 then for second iteration i get last ID of line 1 not line 2 of 2nd itereation !
that's the main reason i needed a workaround like subjobs and temporary files for 1 line only !!
is there by the way any replacement for temp file with 1 line ?? (i need a componenet that can keep data along all the iteration globally to use it for all subjobs while making sure i don't write any column types and names !! my object has around 150 attributes )
is there any solution that is as dynamic as possible to avoid writing code for each column 150 times ?
