Identify multiple active records from source and target table

Anonymous
2021-04-04T11:40:21.857+00:00

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

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,891 Reputation points
    2021-04-05T07:38:21.543+00:00

    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:
    84375-df.png
    84386-unionalltransformation.png

    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.