title: SQL Server 2008R2 SSIS Package for deployment on SQL Server 2008(R1)
body: <p>I think I can probably guess that the answer to this question is going to be NO! </p>
  
  <p>Here goes anyway... I have developed an SSIS package on my local development machine with SQL Server 2008R2 installed.</p>
  
  <p>When I went to deploy on the production server the package failed with all sorts of errors. After digging around I discovered the production server is running SQL 2008 (not R2).</p>
  
  <p>Question: is there a simple way (preferably some simple setting in the IDE) that will make my  package compatible?</p>
  
  <p><strong>UPDATE:</strong> This is the exact error I get when I try to execute the package on SQL Server(R1)</p>
  
  <pre><code> Description: Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException:
   The version of component "ADO NET Destination" (79) is not compatible with 
   this version of the DataFlow.  [[The version or pipeline version or both for the
   specified component is higher than the current version.  This package was probab
   ly created on a new version of DTS or the component than is installed on the cur
   rent PC.]]
  </code></pre>