Share via

self join in ssis

Vineet S 1,350 Reputation points
2025-01-30T18:20:16.8766667+00:00

HI Expert,

If i want to run pipeline for table1 which has self join with same table and updating flag on created and updated on target table... how this this can be done in ssis

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,638 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Felippe Oliveira dos Santos 0 Reputation points
    2025-01-30T20:01:30.47+00:00

    Hi Vineet,

    I don't know if you tried writing CTE, this case, I believe you can use SSIS Execute SQL Task.

    Case you want to share more details, I can help you...

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.