August 11, 2016

SSIS troubles

Posted in SQL Server, SSIS at 1:36 pm by David Taylor

I have an SSIS 2008 R2 package that, for three days in a row, 8/9, 8/10, 8/11 of 2016, has given me the following error:

Error 0xC0011008. Failed to load the package “<Package Name>” from SQL Server “localhost”. Make sure the package exist on the SQL Server and you have the correct credential to access it.

Error 0xC0011008 while preparing to load the package. Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.

This package has been running for well over a year without issue, and nothing has changed, that I know of. It runs under my account, which has admin privileges. When I run the Control package that calls this package, either from BIDS or from a separate SQL Agent job that just calls this package, it runs fine. It’s just in the overnight run that I get this error.

Prior to 8/9/16, this has run without error for well over a year, as I said earlier.

There are no entries in the Event log, which makes sense as the error line states that there wasn’t.

Can anyone help me with this?