Not really I already have a working model using SSIS.

And would like to replicate the same in t-sql.

Any sample codes are appreciated.