CODEWITHSUNDEEP
azuredeploymentssis
Strig
Strig

Reputation: 43

Error when deploying SSIS package to azure

Deploy SSIS package to azure fails on validation from both vs2019 and SSMS environments.

VS2019: "Package deployment is not supported for SSIS in Azure Data Factory"

SSMS: "Package": Connection '....' contains host name.

(my package contains ADO.NET connection manager with server name that points to an azure sql server ****.database.windows.net)

Any suggestions?

ssms

enter image description here

Upvotes: 0

Views: 751

Answers (1)

Tim Mylott
Tim Mylott

Reputation: 2703

According to MS documentation - Validate packages deployed to Azure

  • Host name. If a server property contains host name instead of IP address, validation raises a warning. Packages that contain host name may fail, typically because the Azure virtual network requires the correct DNS configuration to support DNS name resolution.

and the - Deploy and run packages in Azure lift and shift

Deploy projects and packages - You have to use the project deployment model, not the package deployment model, when you deploy projects to SSISDB on Azure.

Upvotes: 1

Related Questions