Hi Dwain

Nice article

The resources link on the article appears to be pointing at the wrong file.

You could also use a Service Broker queue to achieve this.

The queue would let you manage how much you taxed the server by restricting the number of concurrent SSIS packages...

My mistake it was a SQL 2008 R2 server using SSMS 2012

Hi, I just successfully ran this in SQL 2012 using a database at compatibility level 80!!

OK worked it out, though not sure of exact reasoning behind it.

I found this statement in MS help for the Execute As User statement

While the context switch to the database...

When you say slower in dtexec do you mean dtexec.exe or dtexecui.exe?

I found that dtexecui ran very slowly (I believe that this is a known issue and is due to...

Sorted.

Needed to set the stored proc that serviced the queue to run as owner and made sure that owners was in the SQL Agent USer role in msdb and also...

Thanks Nils

The Service broker artefacts are NOT in the msdb they're in my database.

I've read the article you linked to and if I understand it right then setting my database...

In dealing with the holidays, rather than searching for each day in the loop why not just find the next holiday after the start and then check the loop date...