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.