Upgrading from 2008 to 2008 R2 with SSIS

Last Post 29 Mar 2011 07:07 AM by gunneyk. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

28 Mar 2011 04:55 PM

When upgrading from 2008 to 2008 R2, is it advisable to upgrade the version of SSIS also? 

I have a server that serves as our SSIS server, and it is SQL 2008.  I have upgraded the related Database Engine from 2008 to 2008 R2.  Now, I have existing packages that connect to a SQL 2005 database that cannot connect to the SQL 2005 instance.

Any assistance is appreciated.

New Member
New Member

29 Mar 2011 07:07 AM
If SSIS is on the same box then I would upgrade that as well. There are some shared components when you have multiple instances or components on the same box that will get upgraded such as the drives etc.

Acceptable Use Policy