We have a package in production which has suddenly started consuming greater than normal time to execute. On debugging this further, we found the following:
The package takes 5 mins to come out.
The queries inside the package, if run seperately, come out in milliseconds in total.

On looking through the sql trace when the package was run, it was found that an insert on a global Temp table is consuming around 5 mins...