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 errorError 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 0xC0202009what to do now??any help is highly appreciatedkipjumber |
|
|
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 ShawSQL Server MVP |
|
|
|
|
|
|
missing DEK