How do I display end date, start date and current flag in slowly changing dimension :SSIS

SK 1 Reputation point

I am trying to display end date, start date and current flag using Y/N as values in a slowly changing dimension in SSIS package. The SSIS slowly changing dimension gives the option of choosing between showing start and end date or showing current flag. I want to input a code that inserts Y if end date is null else N for all the other fields in the current flag column. Can some body please help me on how to achieve the additional information using derived column or any other means in the SSIS package.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,485 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,896 Reputation points

    Hi @SK ,

    Could you please share the example data in the table?

    The following columns will be added to the product dimension table.
    1.StartDate (DateTime) – Start date for this product to being active and related to new sales
    2.Status (Boolean) – 0 means not active, 1 means active
    3.Enddate (DateTime) – End date for this row to be inactive but still related to historical sales

    Please refer to the following links:
    Slowly Changing Dimension Transformation

    Managing A Slowly Changing Dimension in SQL Server Integration Services

    Best regards,

    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.