• Ah yes, I understand. You cannot deploy SSIS 2012 projects to SQL Server 2008R2 or older. You can only deploy to SQL Server 2012.

    In Visual Studio 2010 (SQL Server Data Tools), you can only create SSIS 2012 projects. So if you want to create SQL Server 2008(R2) projects, you need to use Visual Studio 2008 or BIDS.

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