Search code examples
ssisscd

Does the System::CreationDate in the Slowly Changing Dimension have something to do with the date when the ssis package was created?

I created an SSIS package composed of OLE DB Source connected to an SCD. Inside the SCD, I ticked the radio button for "Use start and end dates to identify current and expired records" I choose

Start Date column: RecordStartDate End Date column: RecordEndDate

variable to set date values : System::CreationDate

If I run the ETL today (November 5, 2013) and check the destination table after running the ETL. The RecordStartDate uses the date when I created the SSIS package (October 18, 2013). Shouldn't the package use the date when the ETL was run? correct me if I'm wrong.

Solution 
  • System::CreationDate - The date that the package was created.

    Shouldn't the package use the date when the ETL was run?

    No, package should use the date then the package was created.

    SQL Server Integration Services System variables