A lot of our data processing requires us to do a step in ETL, then in SSIS and then in ETL because ETL can't do things like trigger stored procedures, etc.
It would make dataprocessing a lot smoother and easier to automate if ETL could trigger these processes and also send commands like "Update xyz where data = abc".
Yes the last example can be done by first extracting the data and then sending a load back with a delete function, etc but it would be a lot more efficient to simply to send the update statement.
