Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kipjumba
Starting Member
1 Post |
 Posted - 2010-07-16 : 14:40:11
|
I am trying to view tables of a databse and get error missing DEK
(Microsoft SQL Server, Error: 824)
It is a database I just restored successfully from a disk backup.
All i need from this database are the contents of a particular table, I tried exporting from the database and I get the following error
Error 0xc0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - INVENTORY" (1) returned error code 0xC0202009
what to do now??
any help is highly appreciated
kipjumber
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-07-17 : 01:33:57
|
You you set proper logins and permissions?
Error 0xC0202009 indicates failed login.
N 56°04'39.26"
E 12°55'05.63" |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-07-17 : 06:23:42
|
Please run this on the source database (Error 824 is corruption)
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Post the full and complete output.
--
Gail Shaw
SQL Server MVP |
|
|
|
|
|
|
missing DEK