got ya makes sense thanks again

Thanks very much appreciate it.

Hi John while waiting for your response I found a way to deploy I simply provided my windows login details in the impersonation tab and that seem to do the...

Thanks John I checked this and changed it to the option Use the credentials of the current user this gave me an error which stated this impersonation mode is not...

Appreciate the response unfortunately my contract has ended with this client so the next resource is challenged with fixing this issue. Again appreciate the response.

Regards,

Hi Joe this wasn't quite the answer but your response was the catalyst to get me thinking in a different way which eventually got me the solution. It turned...

Sorry for my delay in response -- thanks very much for all the suggestions the document posted was extremely helpful and eventually helped me resolve my problems. Essentially what...

Perfect -- Thanks a million.

Thanks this is exactly what I wanted. Now I am able to set this up for an individual ID that is already available in the DB but would you...

Sorry yes reporting services is in place already. How would I give Browser rights? I have already deployed the reports to a server, would it be during the...

What did you change the encryption to and from what. I have mine set to EncryptSensitiveWithUserKey.

The parent package is calling the child package via an Execute package task. I know the file name is correct because when setting up the job I map to...

I really appreciate all your assistance on this -- I have checked which login is the one for the SQL Agent and have given it full permissions and access to...

One other note I am using a copy of the solution to schedule -- sorry I should have mentioned that before.

Would you know how to check the login being used for SQL Server Agent. My network admin is not very SQL Server literate. When I look in security...