The Multifunctioning DBA

Apr 23 2009   9:31PM GMT

DTS Migration to SQL Server 2008 SSIS



Posted by: Colin Smith
Tags:
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.

2  Comments on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Deepfat
    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)
    15 pointsBadges:
    report
  • Colin Smith
    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.
    885 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: