Viewing 15 posts - 1 through 15 (of 19 total)
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...
January 9, 2020 at 9:24 am
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...
January 8, 2020 at 10:36 am
I'm not too worried about the AVERAGE PLE
Right now it's 15165
What worries me is when it dips to 60
October 4, 2019 at 2:13 pm
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'....
August 7, 2019 at 11:03 am
Probably permissionsBut in my case, it wasn'tError 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).BUTSomeone...
March 12, 2019 at 11:24 am
I've been wondering myself - since mirroring is now deprecated in favour of Always On, I think it is a minority sport these daysMicrosoft sets these defaults - Unsent...
January 14, 2019 at 9:03 am
bangsql - Friday, January 25, 2013 11:15 AM
Execute following ---use dbnamegoexec sp_updatestats(this sp will detect and automatically update only require)
Too good to...
June 21, 2018 at 4:38 am
This may be helpful
June 18, 2018 at 2:15 am
Namaste Vereen-JiYour suggestion fixed my problem!
Using the wizard to create the table hasactually created a matrix. This...
March 22, 2018 at 4:53 am
Thanks Spiff - I had indeed renamed the field, and SSRS hadn't picked it up
January 9, 2018 at 3:55 am
Thank you - that makes sense, even though the error message does not! The server is low on space and I have asked for more
September 14, 2016 at 3:29 am
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 ...
September 13, 2016 at 3:49 am
It works for me too!
Can you explain why, or should I just chalk it up to SSIS Weirdness?
August 26, 2014 at 7:32 am
suggests that service pack has not been applied correctly – redo that and problem should go away
August 13, 2014 at 9:50 am
That old? Hope they haven't been waiting all this time for my bug fix...
December 18, 2012 at 11:06 am