Transform it self says that Slowly Changing Dimension so my Opinion is not to us SCD in SQL server 2012 use lookup and merge statement which is available from sql server 2008 ,by Sql it self will do both insert and update as scd works and gives best performance so never try to use SCD transformtaion.

My opinion is use look up for match and un match records and merge statement in sql ..

AS scd works row by row operation...

Try in net. you different examples for replacement of SCD transformation.