Moving the question here, as advised on Stack Overflow
I'm facing a very strange issue when deploying a SSIS package that is part of a project:
I have 3 Azure SQL Servers running 2014.
I've written a task using C# to parse quite a complex XML file, created the outputs to insert in multiple tables simultaneously and all works fine both on my local machine and on the DEV server (which is an azure machine just like UAT and PROD).
When executing the package in either the UAT and the PROD servers, I get the error:
Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: The version of SCR Get BBG data 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 probably created on a new version of DTS or the component than is installed on the current PC]]
On the script task, the script language is set to C# 2012. I am not using any 3rd party DLLs or references inside the script. The only references I've added were to XML and Linq:
I have the build setup for any CPU, target .NET framework is 4.0. On the project properties, Target Server is set to SQL Server 2014.
I've checked in all 3 servers and they all have all the versions of the .NET framework installed, including 4.0 and 4.5. I have also checked and
System.Xml.Linq are on the servers as part of the .NET framework.
The way we install the projects is by creating an ISPAC exporting from the build machine and then run the deploy on the targets. All 3 Azure servers have the same configuration.
I've found some other posts talking about similar problems and the solution appeared to be to change the configuration properties of the project and turn off the option
"Run64BitRuntime" in the debugging, but that hasn't worked.
I've been stuck with this issue now for a week and have exhausted all the search sites I know of.
Has anyone ever had this happening before? Any other suggestions of what can be wrong? Is there any further information I can provide that might help?