SCD in SSIS

Create table Scdemp
 (EmpBusinessId int,EmpName Varchar(20),age int,MaritalStatus varchar(10),ManagerId int)
 go
 Insert Into scdemp values (1010,'M',45,'M',1008)


Create table DestScdemp
 (EmpBusinessId int,EmpName Varchar(20),age int,MaritalStatus varchar(10),ManagerId int,EmpSurrogateId Int,StartDate Date,Enddate DATE )