The reason why I use T-SQL for this is because it's frequently much better to do things there. So much so that a lot of people will build "Execute T-SQL" tasks into their SSIS packages because it's either impossible to do in SSIS or a whole lot easier to do in T-SQL.

Since I work with some companies that don't even allow for an SSIS instance, I better know how to do it all in T-SQL. I've even setup systems that log onto FTP sites, down load information, import to stagig table(s), validate the data, move to the final tables, and report it all... and all if it done without ever going near either SSIS or SSRS.

It does take time to learn enough to get to that point, though. That's why they invented things like SSIS... some of the tasks I mentioned are canned and ready to use and you don't necessarily need much knowledge to do such things.

And, no... I don't believe that you could do what we've done in code in SSIS. I could be wrong, though because, like I said, I don't use SSIS. 😀