I will try that with a trace, we have looked at using top, but it has not been very effective. The only difference between the two is one gets copied and runs in a query window in ssms and the one in SSIS uses the file with the code from Execute SQL Task, then in General -SQL Statement we use file connection and the option just above that we link to the file with the exact same code run through SSMS Query.

I will test profiler in a few days only as we are in the middle of a TEST ETL for one Client, and just after that another Client is going live, for now I will use scripts directly where we have cursors and for the rest of the code, I will use SSIS.