October 16, 2015 at 3:08 am
Hi,
Can this possible to migrate DTS packages to SQL SERVER 2012?
we are planning to migrate a 50 DTS packages to 2012.
Recreating the packages was bit difficult as they were created years back and were running on production system.
Can any one tell me how to proceed.
Appreciate your quick response.
Thanks in advance;; 🙂
🙂
October 16, 2015 at 3:22 am
Will require upgrading to 2005/2008 then to 2012
October 16, 2015 at 3:43 am
After using the migrating wizard to sql server 2008, it tried to upgrade them to 2012 but it was failed with the following error.
TITLE: Microsoft Visual Studio
------------------------------
Error at Business_Unit_Dimension_Load_Execute_Parent []: The "Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask, Microsoft.SqlServer.Exec80PackageTask, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" task has been deprecated and cannot be used with this version of Integration Services.
Error at Business_Unit_Dimension_Load_Execute_Parent []: Failed to decrypt protected XML node "SQLPassword" 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.
Error at 1_DM Load Business Unit Dimension []: Failed to load task "1_DM Load Business Unit Dimension", type "". The contact information for this task is "Execute DTS 2000 Package Task; Microsoft SQL Server 2008 R2; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1".
Error at Business_Unit_Dimension_Load_Execute_Parent []: The "Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask, Microsoft.SqlServer.Exec80PackageTask, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" task has been deprecated and cannot be used with this version of Integration Services.
Error at Business_Unit_Dimension_Load_Execute_Parent []: Failed to decrypt protected XML node "SQLPassword" 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.
Error at 2_DW Load Business Unit Dimension []: Failed to load task "2_DW Load Business Unit Dimension", type "". The contact information for this task is "Execute DTS 2000 Package Task; Microsoft SQL Server 2008 R2; © 2007 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1".
------------------------------
BUTTONS:
OK
------------------------------
October 16, 2015 at 3:54 am
You will need to find the tasks which cannot be upgraded, eg ActiveX tasks etc and re-code them for 2012
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply