You are not logged in.
As nkxxDV said, you can use the tUniqueRow before tMssqlsp, it will filter the duplicate rows and only transform the unique rows to tMssqlsp.
tUniqueRow is made for this isn't it ?
This would only be a problem if you had a lot of data, as this component loads every row in memory.
Then you'd have to find a workaround ...
I'm using a tMSSqlSP who call a stocked procedure. When the procedure detect duplcate rows, it stop and doesn't go to the next row.
Is there a way to manage that ? If a duplicate row is detected, I just want to avoid id and to go to the next row.