Identify multiple active records from source and target table

Question

Hi All, I have a requirement where I need to design SSIS package to identify multiple active records for a given promotion value. Source data looks like below. ![84255-image.png][1] next execution, for same promotionid having different start date(01/30/2021), end is 12/31/9999. This record is in valid. Because in target table already we have one active record for this promotionid. ![84230-image.png][2] The above record is valid when the data in below format. ![84295-image.png][3] Can some one guide me how can we design SSIS package for this requirement. Regards, pc [1]: /api/attachments/84255-image.png?platform=QnA [2]: /api/attachments/84230-image.png?platform=QnA [3]: /api/attachments/84295-image.png?platform=QnA

Answer 1

Hi <em name="deleted_6646735">anonymous user</em> ,

May I know if you want to load all the data in two source tables to one destination table?

If so, we can use Union All Transformation in SSIS package.

Please refer to the following pictures:

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.