self join in ssis

Vineet S 1,370 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,644 questions
{count} votes

Accepted answer
  1. Felippe Oliveira dos Santos 75 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...


0 additional answers

Sort by: Most helpful

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.