question

ShivendooKumar-8455 avatar image
0 Votes"
ShivendooKumar-8455 asked Monalv-msft edited

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

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
capture45.png (111.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ShivendooKumar-8455 avatar image
1 Vote"
ShivendooKumar-8455 answered Monalv-msft edited

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://docs.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ShivendooKumar-8455 ,

I am glad to hear that you have solved the issue.

Please mark your own answer.

This can be beneficial to other community members reading this thread.

Best regards,
Mona


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 Votes 0 ·