Monthly Archives: January 2011

Failed to decrypt protected XML node “DTS:Property” with error 0x8009000B “Key not valid for use in specified state.”

TITLE: Microsoft Visual Studio ——————————————— There were errors while the package was being loaded. The package might be corrupted. See the Error List for details. ——————————————— BUTTONS: OK ——————————————— Error    1    Error loading xyz.dtsx: Failed to decrypt protected XML node … Continue reading

Posted in SQL Server, SSIS, Troubleshooting | Tagged , , , , | 4 Comments

File attachment or query results size exceeds allowable value of 1000000 bytes

Msg 22051, Level 16, State 1, Line 0 File attachment or query results size exceeds allowable value of 1000000 bytes. Send mail task in a DTA package failed with the below error attaching a .csv file of 3MB. File attachment … Continue reading

Posted in Database Mail, SQL Server, Troubleshooting | Tagged , | Leave a comment