question

$$ANON_USER$$ avatar image
0 Votes"
$$ANON_USER$$ asked Monalv-msft commented

Identify multiple active records from source and target table

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]: /answers/storage/attachments/84255-image.png [2]: /answers/storage/attachments/84230-image.png [3]: /answers/storage/attachments/84295-image.png

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft commented

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.




df.png (76.9 KiB)
unionalltransformation.png (14.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image Monalv-msft ·

Hi ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·