• Yes, you can connect from SSIS 2012 to SQL 2014.

    There are no notable difference between SSIS 2012 and 2014, aside from the development environment (SSIS 2014 uses VS 2013), so the SSIS group shouldn't expect that much of a negative impact.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP