Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·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·330 readsDebugging SSIS ErrorsSSIS
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·Jan 30, 2023SSIS Error: Cannot create a task from XML for task, "task" type Microsoft.ExecuteProcess due to error 0x80070057 "The parameter is incorrectBackground: I have created a SSIS package in visual studio 2019 and tested it. It was working fine. When I tried executing the package from the SQL Server agent, I was getting different errors. This is the simplified version of the package. Even tho...Discuss·231 readsDebugging SSIS ErrorsSSIS
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·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·77 readsDebugging SSIS ErrorsSSIS
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·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·77 readsDebugging SSIS ErrorsSSIS
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·Jan 31, 2023SSIS Error: Failed to open package file "T:\SSIS\Package.dtsx" due to error 0x80070003 "The system cannot find the path specified.".Problem: I was trying to execute the SSIS package through SQL Server Agent and got the error below. Error Message :Message Executed as user: NT Service\SQLSERVERAGENT.Microsoft (R) SQL Server Execute Package Utility Version 15.0.2000.5 for 64-bit Co...Discuss·72 readsDebugging SSIS ErrorsSSIS
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·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·330 readsDebugging SSIS ErrorsSSIS
Rajanand IlangovanforRajanand's Blograjanand.hashnode.net·Jan 30, 2023SSIS Error: Cannot create a task from XML for task, "task" type Microsoft.ExecuteProcess due to error 0x80070057 "The parameter is incorrectBackground: I have created a SSIS package in visual studio 2019 and tested it. It was working fine. When I tried executing the package from the SQL Server agent, I was getting different errors. This is the simplified version of the package. Even tho...Discuss·231 readsDebugging SSIS ErrorsSSIS
