Its using an SSRS datasource calling a stored procedure.

Yeah i see what you are saying but it isnt giving me the option of entering a different user. The only way i have found of doing it so far...

Thanks for that. I didn't see that option when looking before but i was looking on my local machine not the server, when i logged onto the server i see...

Yes, i used that article myself and did reference back to it to make sure i wasnt going mad when i found my issue.

It is looping through ok and updating...

That looks like it will give me the desired result i will test it this afternoon. Thanks a lot for such a quick response.

John