Unfortunately due to the DB policies where I work SQL Agent is not an option that is available to me.

You are calling this console app on the machine that has...

A bit more background of what I have tested, my client app is a simple console application.

I've dumbed my SSIS package right down so it just executes a query statement...

Thanks for the reply.

I've read that article and similar ones several times over. I've even tried implementing the sugessted code snippet from http://support.microsoft.com/kb/889251.

Thought I'd try this forum as an alternate...

Apologies, typo mistake.

I'm running a SSIS package using DTExec.exe.