Can a pause be added to script/map?
I am building a map with a pre map SQL task command task which executes a SQL job. The sql job executes and SSIS package to pull invoice records from a Cloud application.. I would like to pause further processing of the map until the job completes.
Is there a way to accomplish this?