SSIS Project Deployment is failing with following Error. Target Version is 2016 and SQL Vwersion is 2017

Shivendoo Kumar 736 Reputation points
2021-03-16T23:38:59.163+00:00

Hi All,
Today I was trying to deploy an SSIS Project to SSIS Catalog using SSDT and it kept failing.

The error message was:
78504-capture45.png

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
0 comments No comments
{count} votes

Accepted answer
  1. Shivendoo Kumar 736 Reputation points
    2021-03-16T23:44:22.643+00:00

    Hi All,
    I realize that this project has packages that are uploading files to Blob Storage using "Azure Blob Upload Task" this is causing an issue. If I delete the Blob connection and related components It allows me to deploy the packages.

    When I checked the Server where SSIS Service is running and found that "Microsoft SQL Server 2017 Integration Services Feature Pack for Azure" is not installed on the machine.

    I downloaded: For SQL Server 2017 - Microsoft SQL Server 2017 Integration Services Feature Pack for Azure and installed and the issue reolved.

    https://learn.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful