I have a client that is not ready to migrate to SQL Server 2012, and actually just finished a migration to 2008R2. Our licenses grant us to SQL 2012, but downgraded to match the production environment.
My question is: Are there any possible negative side-effects to using only the SSIS portion of 2012, but using the SQL server half of 2008.
Main driver: Allow tighter/easier TFS integration with VS 2010, to move away from VS2008. Plus, a lot of the features in SSIS 2012 would help solve some pain points we've seen in our ETLs.