User access to run packages from within a main package

[Strobeman]

I have got a main package which runs a few sub packages. I deployed it to a test server and all worked well logged in as Administrator. My next step was to create a user with just enough privileges to kick off the package.
Unfortunately it is now giving me the following message: "The SSIS logging provider has failed to open the log. Error code: 0x80070005. Access is denied." I tried removing all the logging but it makes no difference.
When I disable the sub packages it works fine. Do I need to somehow give the user access to execute each one of the packages? I am using 2005 by the way.

 

[MDXer]

check the security to make sure that your parent has permissions to the child packages.

 

[Strobeman]

Thanks MDXer, I am rather new at this and was wondering if you could be more specific? I made sure my user has access to launch applications in Component Services and he has read/write access to all the folders but I am not sure how to check the parent's permission to run the child packages.

 

[MDXer]

Check the encryption level for the packages.

 

[Strobeman]

I am using EncryptSensitiveWithPassword

 

[Strobeman]

Thanks for all you help so far MDXer. I seem to have found the solution. My main package has a config file containing the folder location for my logs. I was then passing this down to my sub packages using a parent variable. When the child package tried to write the log it was not picking up the folder location first and so it was trying to write to the root. Since my user does not have access to the root it was falling over. I have fixed this by sharing the config in each of the child packages. I have since found other people with the same problem on the net and if anyone has any other ideas of getting around this, I would love to hear them. Many Thanks!

 

[MDXer]

Glad you solved it. An easier way of handeling situations where a Package passes a non dynamic variable such as this is to load it as a configuration for each package, stored in a table or config file. I prefer database tables as a config file can start looking ugly fast.