Our company has SQL Server 2008R2 and plans to upgrade to 2012 in late 2013 or early 2014. I would like to use SSIS 2012 now as we do have the software.
We have a company policy where we cannot run SSIS packages on the database server itself. We run them from another app server, not integrated services.
My question is, if I were to install all 2012 composent for SSIS on our app server would there be any potental issues? I have not used SSIS 2012 yet so I do not know if the OLE DB compoents Id use to point to our SQL 2008 instance would be an issue.