Microsoft have an article on how they use DTS with type 1 and type 2 SCD (Slowly Changing Dimensions):

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_busintbpwithdts.asp

I don't think you will be able to avoid using T-SQL. ...