Error from ADF IR using SSIS The version of Script Component is not compatible with this version of the DataFlow

Question

I have had a ADF pipeline working for the past year that triggered every day that basically started my IR then ran a SSIS package then shutdown the IR. Recently I needed to update the SSIS with some new code. I am currently using azure blob storage for the location of the SSIS package and assumed just copying the updated package would work. Of course it didn't. After working through multiple issues I am now gectting the following error when running the package

{
	"OperationErrorMessages": "1/22/2024 11:30:22 PM +00:00 : Load ECNL:Error: Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: The version of Script Component 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.]]\r\n   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)\n1/22/2024 11:30:22 PM +00:00 : Load ECNL:Error: The component metadata for \"Script Component\" could not be upgraded to the newer version of the component. The PerformUpgrade method failed.\r\n\n1/22/2024 11:30:22 PM +00:00 : Load GotSport:Error: Microsoft.SqlServer.Dts.Pipeline.ComponentVersionMismatchException: The version of Script Component 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.]]\r\n   at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostCheckAndPerformUpgrade(IDTSManagedComponentWrapper100 wrapper, Int32 lPipelineVersion)\n",
	"effectiveIntegrationRuntime": "SSIS-V2 (East US)",
	"executionDuration": 16,
	"durationInQueue": {
		"integrationRuntimeQueue": 0
	}
}

My assumption is that since I have updated my SSDT on my local machine that potentially the IR needed to be updated. I could not find a way to update the IR so I went ahead and built a new one. That still didnt not fix the poroblem. Any help would be apprecciated.

Answer 1

Hello Steve Dunker,

Welcome to the Micosoft Q&A forum.

The above error message generally occurs if the script tasks are not built correctly. Since SSIS executables on ADF are compatible with SQL 2017 platform, please set the target server version of your project to SQL 2017 and build the script task.

Please follow below steps to build the script task.

 

1. Open the project in VS and ensure that correct build version is chosen
2. You need to open each script tasks individually -- > Clean --- > Rebuild and save.
3. Please ensure to click OKAY button at the editor. Once all the tasks are build rebuild the package and save it.

A similar error message was discussed on the below URLs.

https://learn.microsoft.com/en-us/answers/questions/127812/ssis-data-flow-task-error-the-version-of-the-flat

https://nishantrana.me/2018/10/29/solved-microsoft-sqlserver-dts-pipeline-componentversionmismatchexception-the-version-of-the-script-component-is-not-compatible-with-this-version-of-the-dataflow/

I hope this helps. Please let me know if you have any further questions.