Category Archives: SSIS

Database Migration Automated

Its been a while since I posted anything here… Phew… Finishing a very tight deadline and critical Database Migration Project today. I have done myself some justification by automating the Database Migration work, that would otherwise require me to perform … Continue reading

Posted in .bat scripts, LogShipping, Replication, RoboCopy, Setup, SQL Server, SSIS, T-SQL Scripts, Transactional Replication, upgrade | Tagged , , , | Leave a comment

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