I am trying to update a SSIS package that contains script component. The script component just gets the error description as described here.
I am using the update wizard in SSDT 2015 which should be compatible with SQL Server 2014. (ssdt)
After the Package update wizard runs, I get a warning and information for every data flow that has a script component.
Warning 0x40016044: Load table TableName: Found SQL Server Integration Services 2012 Script Component TableName Error Desc that requires migration!
Information 0x4001601a: Load table TableName: The TableName Error Desc has been migrated. The package must be saved to retain migration changes
This looks to me like the script component has been migrated successfully. I then build and deploy the package to my SSIS instance.
When I try to execute the package on the instance, via SQL agent or Integration Services Catalog, the package fails verification with the following errors.
Load table PersonDisability:Error: Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: The version of tablename Error Desc 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.]] at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)
Load table TableName:Error: The component metadata for "TableName Error Desc" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.
Based on these, if the messages are accurate, I have a version mismatch. My instance is 2014 SP1 CU3 (12.0.4427.24) and my SSDT that I did the package update with is 2015(14.0.51128.0)
Are these versions incompatible?