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?
Best Answer
VS 2010/VS 2012 => SQL Server 2012.
VS 2013 => SQL Server 2014.
VS 2015 => SQL Server 2016 (for now, soon they'll have the ability to target SQL Server 2012+)
So, you either need to redo your imports using SSDT for VS 2013/SQL Server 2014 or wait until they deliver the next release candidate for SQL Server which will have the ability to target specific releases of SSIS