Implementation of slowly changing Dimension Type-0 The Passive method (Ignore updates) using SCD Transformation in SSIS

We can implement the SCD type -0 using the SCD transformation.

Read: Implementation of slowly changing Dimension Type-0 ThePassive method (Ignore updates) using SQL script in SQL server

https://bageshkumarbagi-msbi.blogspot.com/2022/05/implementation-of-slowly-changing.html

Taking Data flow task 

Taking Source as OLEDB and doing the configuration.  

Now we are taking  SCD transformation and clicking  

Providing the connection manager and selecting the destination table. After that we are selecting the Business key. Business key is nothing but on which condition we are going the update.

Click on the next button.  

Selecting the Dimension columns and Change Type as Fixed attribute. Click on the Next button.

  

If we check mark this check box then if we get any change record in PAN or Aadhar Number it will fail the package. If Uncheck this box then we can either ignore that record or we can Audit that record.

Here we are auditing the record.

  Click on Next.  

Here we are not enabling the inferred member support.

Click on the next button. 

Click on the Finish.  

Now we can add one more destination to audit in case if there is any changes in the dimension attribute.

                          
Basically in the derived column transformation we are creating two new columns one is for application name and column for audit message.  

After that we are taking a OLEDB destination and doing the mapping.  

Our package looks like below  

Before running the package records in the table.  

Running the package now.  

Package is executed successfully.

See the records in the table. 

Get the expected result.