No, the SCD transformation in SSIS only handles Type 1 and Type 2 SCDs...but I wouldn't use it at all because it performs poorly in terms of speed. Better to 'roll your own' using, for example, the T-SQL MERGE statement. There are 3rd party components available that perform orders of magnitude better, but none of them are free AFAIK.

Regards

Lempster