Azure-SSIS Supports SSIS 2017 Only

With the recent public preview release of Synapse-SSIS, I want to remind SSIS developers that Azure-SSIS integration runtimes – be they configured in Azure Data Factory (ADF) or in Azure Synapse Analytics – support only SSIS 2017 packages. Errors most often occur when executing SSIS packages that contain script tasks or script components.

If you deploy an SSIS 2019 package containing a script object to either ADF or Synapse integration runtime’s SSIS Catalog, package execution will fail with the error:

Error: Cannot load script for execution.

(click to enlarge)

The Fix

To correct this issue:

  • Open the SSIS project in Visual Studio
  • In Solution Explorer, right-click the project name
  • Click Properties
  • When the SSIS project’s Property Pages display, click “Configuration Properties” in the left-most list
  • Click the TargetServerVersion property dropdown and select SQL Server 2017 for SSIS 2017 packages:

The error is identical in Azure Data Factory Azure-SSIS and in Azure Synapse Analytics’ Azure-SSIS integration runtimes.

Hope this helps!

:{>

Andy Leonard

andyleonard.blog

Christian, husband, dad, grandpa, Data Philosopher, Data Engineer, Azure Data Factory, SSIS, and Biml guy. I was cloud before cloud was cool. :{>