It was indeed a timeout!

I've changed the timeout from 30 to 60 seconds, and it now loads my data - many thanks!

I was googling the whole error message, rather than...

I am pleased that changing to ADO.net fixed your problem

Unfortunately, I use ADO.net already and it fails!

It might help if the error message was more meaningful

[SSIS.Pipeline] Error: SSIS Error Code...

I'm not too worried about the AVERAGE PLE

Right now it's 15165

What worries me is when it dips to 60

I'm getting a SQL Server Alert System: 'Severity 021' message as of about 90 minutes ago

Unable to find index entry in index ID 0, of table 340842130, in database 'tempdb'....

Probably permissions
But in my case, it wasn't
Error message said:
FCB::Open failed: Could not open file E:\UserDatabases\msdb.mdf for file number 1.  OS error: 2(failed to retrieve text for this error. Reason: 15100).
BUT
Someone...

I've been wondering myself - since mirroring is now deprecated in favour of Always On, I think it is a minority sport these days
Microsoft sets these defaults - 
Unsent...

Too good to...

This  may be helpful

http://www.sqlservercentral.com/blogs/nebraska-sql-from-dba_andy/2017/08/24/the-transient-database-snapshot-has-been-marked-suspect/

Namaste Vereen-Ji
Your suggestion fixed my problem!

1. Using the wizard to create the table hasactually created a matrix.  This...

Thanks Spiff - I had indeed renamed the field, and SSRS hadn't picked it up

Thank you - that makes sense, even though the error message does not! The server is low on space and I have asked for more

I'm having a similar problem

Database is 225Gb

NOT Always On

SQL Server 2012

Slightly different command DBCC CHECKDB ([xxx]) WITH NO_INFOMSGS, ALL_ERRORMSGS, DATA_PURITY

Error says HResult 0x254, Level 21, State 1 ...

It works for me too!

Can you explain why, or should I just chalk it up to SSIS Weirdness?

http://sqlsolace.blogspot.co.uk/2009/05/management-studio-error-object.html

suggests that service pack has not been applied correctly – redo that and problem should go away

That old? Hope they haven't been waiting all this time for my bug fix...

:o)