I need to redevelop an ETL process and I'm evaluating options.
I'm running SQL Server 2008 R2 database, and SSIS 2008 will take too long to develop and test the required packages. I understand that SSIS 2012 is significantly improved and will help me develop the packages far more efficiently, but I don't know about the versioning considerations.
Can I run an SSIS 2012 package on a SQL Server 2008 R2 server? Or can I run it on a SQL Server 2012 database and connect to SQL Server 2008 R2 databases? Are there any issues that I'm going to come across connecting in this way?