I have SQL Server 2005 SP5 on window server 2003R2 with SP3.
2 days back we moved our 1 instance of 2005 from existing server to new server with same infra. I restored the MSDB on new server so that i can have all SSIS package and jobs on new server. All SSIS packages worked fine except which were connecting
to SQL 2000 with DTS package task.
The package which have Execute 2000 DTS package task throws below error in control flow while executing or when i click to edit this task.
TITLE: Microsoft Visual Studio
The task with the name "Execute DTS 2000 Package Task" and the creation name "Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask, Microsoft.SqlServer.Exec80PackageTask, Version=18.104.22.168, Culture=neutral, PublicKeyToken=89845dcd8080cc91"
is not registered for use on this computer.
Execute DTS 2000 Package Task
As per my understanding its due to some version difference, however i am unable to troubleshoot where the version diff is.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.