We are at a company where we are changing their DataMart.

We are looking at whether to do the ETL using SSIS or just use one SQL to do
it (which is how they do it now).

The DBA is for using one SQL procedure to handle it because many sql
developers don't know SSIS and it would be harder to make changes. Right
now he can just hand the procedure to any of his developers to make changes.

This is going to be a complete rewrite as we are redoing the DataMart so the
ETL will change completely. We started to do it with SSIS but ran into this
issue and are just looking at good reasons to use SSIS over the old way.

Thanks,

Tom