Possible incompatibility between latest SSDT 2017 and SSIS Integration Runtime in Data Factory
I downloaded the latest version of SQL Server Data Tools 2017, which has component Microsoft SQL Server Integration Services Designer 15.0.X.Y
All my deployments to SSIS Integration Runtime (hosted using Azure SQL Server) failed when using Script Task saying "Cannot load script for execution".
I first thought it'd be a problem in my laptop, but then I benchmarked with one of my peers, he downloaded the same SSDT version and his packages got the same error.
Then I downloaded the earliest possible version of SSDT 2017 (15.6.X) which includes component Microsoft SQL Server Integration Services Designer 14.0.X.Y.
Packages worked fine after that.
Thank you.

1 comment
-
Rodge commented
Hi Homero,
Thanks for reporting the issue, we have already known about it and working on the fix. You can find more details and workaround at: https://docs.microsoft.com/en-us/sql/ssdt/changelog-for-sql-server-data-tools-ssdt?view=sql-server-2017
Thanks,
Rodge