Home > IT Blogs > The Multifunctioning DBA > DTS Migration to SQL Server 2008 SSIS
>>VIEW ALL POSTS  

The Multifunctioning DBA

«
»
Apr 23 2009   9:31PM GMT

DTS Migration to SQL Server 2008 SSIS



Posted by: Colin Smith
Database Administration, DBA, Installation, SQL Server

Today I had a developer ask about moving old DTS packages into SQL Server 2008 SSIS. This is our first real test SQL Server 2008 instance and we had never done this. He was attempting to use the Package Migration Wizard to move the package into SSIS. We installed the BI Visual Studio Components and also the Backward Compatibility Components during the SQL Server 2008 installation. We verified all this and asked if he could try again. He did and sent us the same error. I found the following article that explains how to resolve the issue.

http://msdn.microsoft.com/en-us/library/ms143755.aspx

Apparently, in MS’s infinite wisdom, the decided that you will also need to install the following.

SQLServer2005_BC*.msi

This on the install media you just need to dig down and find it. Once we installed this everything was fine and the developer was able to move the DTS package over using the Wizard. Not sure why they make us do an additional install that is not available during the install of the product.

  Bookmark and Share     Comment     RSS Feed     Email a friend

Comment on this Post

Leave a comment:

Deepfat  |   Apr 24, 2009  6:09 AM (GMT)

The backward compatibility stuff is part of the SQL Server feature pack, http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
and we don’t put all this in by default to keep the size of the install down and reduce it’s complexity as it’s not always needed. My other comment would be that DTSXChange is the killer tool for migrating DTS to SSIS.
Andrew (afryer@microsoft.com)


 

Smithc32  |   Apr 24, 2009  4:26 PM (GMT)

Deepfat,

First thanks for the comment and the explanation. I understand that you do not want to fatten up the default installation with things that may not be used and I appreciate that. The only complaint I have with it is that I can not select this backwards compatibility component during the standard installation or when I try to add features to a currently installed instance. I would like to see the option there and not have to dig down into the installation media to find that one MSI to do the install.

Thanks again for the comment on this.