CODEWITHSUNDEEP
sql-server-2008ssis
bigtv
bigtv

Reputation: 2711

SQL Server 2008R2 SSIS Package for deployment on SQL Server 2008(R1)

I think I can probably guess that the answer to this question is going to be NO!

Here goes anyway... I have developed an SSIS package on my local development machine with SQL Server 2008R2 installed.

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).

Question: is there a simple way (preferably some simple setting in the IDE) that will make my package compatible?

UPDATE: This is the exact error I get when I try to execute the package on SQL Server(R1)

 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.]]

Upvotes: 2

Views: 10041

Answers (1)

Michiel Matthijssen
Michiel Matthijssen

Reputation: 46

It seems ADO NET destinations are the only incompatible things between 2008 and 2008R2. For a solution, see: http://agilebi.com/jwelch/2010/05/13/moving-ssis-packages-with-ado-net-destinations-between-2008-r2-and-2008/

Upvotes: 3

Related Questions