SSIS: Package Validation Error: THe SSIS logging provider has failed to open the log. Error code:0x80070005

I have a working SSIS package being converted from VS 2005 to VS 2008.  Logging has worked correctly for years.  I use an Expression for the connection string of the connection manage for the log file:
"\\\\" + @[System::MachineName] + "\\OxmoorHouse\\SSIS_Logging\\OH_CAP_Grids_Build\\" + @[System::PackageName] + "_" + Right ("0" + (DT_WSTR, 4) DATEPART("YEAR", @[System::StartTime]) ,4) + "_" + Right ("0" + (DT_WSTR, 2) DATEPART("Month",  @[System::StartTime]) ,2) + "_" + Right ("0" + (DT_WSTR, 2) DATEPART("Day",  @[System::StartTime]),2) + "_" + Right ("0" + (DT_WSTR, 2) DATEPART("Hour",  @[System::StartTime]),2) + "_" + Right ("0" + (DT_WSTR, 2) DATEPART("Minute",  @[System::StartTime]),2) + ".txt"

After conversion, I tested the package on my Dev SQL machine .  Worked fine except I noticed the expression for the log file connectionstring on the connection manager vanished.  I re-added the syntax above.  Now with or without the expressions I get the following error:
Package Validation Error:  The SSIS logging provider has failed to open the log.  Error Code: 0x80070005.

Facts:
1.  Delay Validation is True on the package and the connection manager.
2.  Permissions to the directory and files for the log files is full control for all users.
3.  Usage Type for the file is Create file but i have tried Existing with no difference.
4.  The expression is correct as I have Evaluated it and confirmed the path is correct.
5.  I have removed the expression and returned to using a fixed name file, fails with same message.  Nothing works now.

I cannot identify anything else that has changed since the last successful execution.

Suggestions?
OHISAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hspoulsenCommented:
One thing that bit me very hard when going from SQL Server 2005 to 2008 was the way that SSIS handles NULLs.

I had to change each and every place where NULLs could occur.
The worst part was all the Script Components in the Data Flows.

I cannot see if that is your problem, though.
OHISAuthor Commented:
Nulls are not the issue.  As I stated, this was a working package.  I converted to 2008, it dropped the expressions but ran to a fixed log file.  I edited to add the expression back into the connection string of the log file, now it fails with or without the expression.  I can get it to run if I turn logging off.

I am running this from BIDS not the server, at this point.  i have not deployed the new version to the development server; I am just pointing there, dynamically for testing purposes.
OHISAuthor Commented:
Solved it.
The location of the logging is dynamic, but on the my PC it is a directory that has a Share on the root of the log directory.  On my PC, I had declared the directory to be full control to all users.  The share had read only permissions and as we all know. Microsoft likes most restrictive permissions so The log was unable to pass the share permissions.  i opened the share, log writes.

Thanks for your time hspoulsen.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hspoulsenCommented:
I'm glad you solved it, and I hope for you that NULL will not bite you, as I was bitten.
OHISAuthor Commented:
I resolved the problem after discovering the layered permissions.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.