Question: how to do scd in ssis?
Answer: Create a new SSIS Integration Service Project -> On control flow tab drag and drop Data Flow Task. ...  Open up SQL Server Management Studio and create a new table and some data to it why because we want to update existing matching data with source data as shown in below image.