Brilliant. That's exactly what I wanted.

Thank you.

One day I'll learn to give you all the information at the first go.

There are more different stages then just Bus_Written and I need to include them too. That's...

Sorry, here the the complete statement

Select

oppo_opportunityref

,oppo_stage

,oppo_closed

From

Opportunity

Where

Case Oppo_stage When 'Bus_Written' Then...

I found out the proble. I was using a mapped drive in my connection string and not the full connection string. Once changed the report worked fine.

I have managed to create a proxy account and assign myself to it but I'm still getting error messages every time I run it. The message now reads:

11/19/2012 10:21:31,AML Data...

JXYZCUSR has read access but not write access.

I see that the job was invoked by me (ELSTREE/ssmith) but executed by JXYZCUSR. How do I change JXYZCUSR to ssmith?

Going on from this, I'm trying to use this SSIS package in a SQL Server Agent job. I create a new job, add a step using the SSIS package and...

Thanks for the help. Setting the property to false worked. I knew it would be simple. 🙂

Thanks guys. That was a great help.

Thanks for you help.

To take my problem one stage further, what I'm really trying to do is find every record in my database that has a companyid of 8514. How...

Thanks for the help. That seems to have worked.