В мене на комп'ютері встановлений SQL Server 2008. Зробив у SSIS Package, локально все працює.
Хочу запустити цей Package на сервері (на ньому стоїть SQL Server 2005). Відкриваю Solution зі своїм Package і отримую купу помилок, запустити Package не виходить:
Error 1 Error loading Package.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. e:\websites\tool\sio\Package.dtsx 1 1
Error 2 Error loading Package.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. e:\websites\tool\sio\Package.dtsx 1 1
Error 3 Error loading Package.dtsx: Error loading a task. The contact information for the task is "Execute SQL Task; Microsoft Corporation; Microsoft SQL Server code name "Katmai"; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. e:\websites\tool\sio\Package.dtsx 1 1
Error 4 Error loading Package.dtsx: Error loading a task. The contact information for the task is "Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. e:\websites\tool\sio\Package.dtsx 1 1
Error 5 Error loading Package.dtsx: Error loading a task. The contact information for the task is "Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. e:\websites\tool\sio\Package.dtsx 1 1
Error 6 Error loading Package.dtsx: Error loading a task. The contact information for the task is "Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. e:\websites\tool\sio\Package.dtsx 1 1
Error 7 Error loading Package.dtsx: Error loading a task. The contact information for the task is "Execute SQL Task; Microsoft Corporation; Microsoft SQL Server code name "Katmai"; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". This happens when loading a task fails. e:\websites\tool\sio\Package.dtsx 1 1
Error 8 Validation error. Categories : The task has failed to load. The contact information for this task is "Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". Package.dtsx 0 0
Error 9 Validation error. Categories : There were errors during task validation. Package.dtsx 0 0
Error 10 Validation error. Cities : The task has failed to load. The contact information for this task is "Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". Package.dtsx 0 0
Error 11 Validation error. Cities : There were errors during task validation. Package.dtsx 0 0
Error 12 Validation error. Clear database : The task has failed to load. The contact information for this task is "Execute SQL Task; Microsoft Corporation; Microsoft SQL Server code name "Katmai"; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". Package.dtsx 0 0
Error 13 Validation error. Clear database : There were errors during task validation. Package.dtsx 0 0
Error 14 Validation error. Firms : The task has failed to load. The contact information for this task is "Performs high-performance data extraction, transformation and loading;Microsoft Corporation; Microsoft SQL Server v10; (C) 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". Package.dtsx 0 0
Error 15 Validation error. Firms : There were errors during task validation. Package.dtsx 0 0
Error 16 Validation error. Update Firms : The task has failed to load. The contact information for this task is "Execute SQL Task; Microsoft Corporation; Microsoft SQL Server code name "Katmai"; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1". Package.dtsx 0 0
Error 17 Validation error. Update Firms : There were errors during task validation. Package.dtsx 0 0
Може хтось стикався з подібним? Не хочеться заново робити Package на комп'ютері з SQL Server 2005 
Artyom Krivokrisenko
Web Reflection, Development Department