DTS Migration Wizard error

I'm using SQL Server 2005 Enterprise x64 and when attempting to migrate a DTS from our SQL Server 2000 Standard x86 server I received the following error message:

DTS Migration Wizard Error

Could not load file or assembly 'Microsoft.SqlServer.Exec80PackageTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of it's dependencies. The system cannot find the file specified.

Click Abort to stop the migration of the current package.

Click Retry to retry the operation.

Click Skip to skip the migration of the current task and continue to the next task.

From the error message, it would appear something did not install or register correctly. Any idea on what is missing and how I can fix it?

Hi there,

Did you do a full SSIS install, or did you install the Migration Wizard by itself? I believe you also need choose "Legacy Components" from the setup if you choose to install the Migration Wizard without the rest of the workbench. That might be the cause of the error you're seeing.

Thanks,

~Matt

|||

I chose to install all (full) components, both server and tools, during my installation of SQL Server 2005 Evaluation Edition. I found it strange that the icon said MS Visual Studio Premier Edition -enu instead of SQL Server Business Intelligence Development Studio. I tried a repair on the MS Visual Studio Premier Edition from Add / Remove Programs but it didn't help. I then removed it using Add / Remove Programs. However, when I fire up the SQL Server 2005 Evaluation Edition setup and attempted to reinstall the tools, it said they were already installed and would not let me go any further. Is a reboot of the production server necessary for Windows 2003 Enterprise to realize I uninstalled MS Visual Studio?

Thanks for your response Matt!

|||

The Visual Studio icon will only be labeled "SQL Server Business Intelligence Development Studio" under the SQL Server folder in the start menu. Your old visual studio icons won't change (they all point to the same thing).

You shouldn't have to reboot after installing SQL Server, but if you've done a repair, I'm not sure what state that puts you in. You might want to uninstall it all and start over again.

The Migration Wizard will be looking for the Microsoft.SqlServer.Exec80PackageTask assembly in the GAC - you might want to make sure it's there. This task gets installed when you select "Legacy Components" or the workbench, so doing a full install should give you all the bits you need.

|||That is the strange part. MS Visual Studio 2005 was not previously installed on this machine; it came across when I chose to install every component of the SQL Server 2005 Eval Edition installation. And the icon in the SQL Server folder didn't say BIDS, instead it was labeled MS Visual Studio 2005. Either way, I have now uninstalled MS Visual Studio 2005 and it looks like I will need to reboot my server before it recognizes the change as it will not allow me to re-install them at this point.|||I ended up uninstalling and reinstalling all of SQL Server 2005 and components. Then to address the missing Business Intellligence projects; I finallly found the answer, In MS Visual Studio (BIDS) click on Tools - Import and Export Settings - Import Selected Environment Settings - Yes, Save my current settings and then highlight "Business Intelligence Settings" and click on finish. This will add the Business Intelligence projects to BIDS.