Even seasoned SSIS developers will try to argue that SSIS packages cannot be tested.
That's utter ….!
Consider the following approach:
Alternatively, not based on tSQLt, but worth considering: