title: How can I create a SSIS package for SQL Server 2008 in a SQL Server 2014 environment?
body: <p>We have SQL Server &amp; SSIS 2014 in our local environment, and most of SQL Server 2014 in our production environment, except for the SSIS, which is still 2008.</p>
  
  <p>So we're creating SSIS packages locally which can't be deployed to production, because the SSIS packages are not backwards-compatible. </p>
  
  <p>Is it possible to create the packages locally to target SSIS 2008? If so, how?</p>
  
  <p>Just to note, the SSIS packages are defined in Visual Studio 2008, so I don't understand why they're dependent on SQL Server 2014.</p>