Rajanand Ilangovanblog.rajanand.org·Mar 21, 2023SSIS Error: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.Problem: We have created an SSIS package to load the data from a database in one server to another server. When tested in the local machine, it executed and data has been transferred as expected. But when we tried executing it through SQL Server Agen...Discuss·1.9K readsDebugging SSIS ErrorsSSIS
Rajanand Ilangovanblog.rajanand.org·Jan 31, 2023SSIS Error: Unable to load the package as XML because of package does not have a valid XML format.Problem: I was trying to execute the SSIS package through SQL Server Agent and got the error below. Error Message :Executed as user: NT Service\SQLSERVERAGENT.Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Copyright ...Discuss·2 likes·3.5K readsDebugging SSIS ErrorsSSIS
