December 11, 2011 at 6:49 pm
I am kind of newbie on this. We need to upgrade SQL server 2005 to 2008 R2 (Both Enterprise Edition). I have over 100 SSIS that I am concerend about. What would be the best approach to upgrade to 2008 R2 from 2005? BTW, we don't use Reporting services or Analysis services just the SSIS.
Thanks
December 16, 2011 at 8:56 pm
Create a Solution in BIDS 2005 or Visual Studio 2005 (VS). Then add a SQL Server Integration Services Project to the Solution. Now add all 100 SSIS packages to the Project (it may be easiest to edit the Project file directly in a text editor to add the XML required to get the packages to be part of the Project). Save the Solution and Project and close BIDS/VS. Now open that same Solution using VS2008. When you open them in VS2008 the Upgrade Wizard will take over and walk you through the process. Note that the Upgrade Wizard does a great job on simple packages with no Script Tasks or Scrinpt Components but it cannot automatically upgrade all packages cleanly. The good news is that it will complain when it fails to do a clean upgrade.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply