在Azure SQL DB上将SSIS项目部署到SSISDB时超时 [英] Timeout when deploying SSIS Project to SSISDB on Azure SQL DB

问题描述

Hi, I am getting a timeout when trying to deploy a package.  The first one I tried worked but all fail after that.

我正在将SSDT 2017和Azure SQL DB与SSMS 2017(V17.6)一起使用

I am using SSDT 2017 and Azure SQL DB with SSMS 2017 (V17.6)

我正在使用为Azure SQL DB和ADF IR运行时设置的管理员登录名，并且正在连接并确认确定.

I am using the Admin login that was set up for the Azure SQL DB and the ADF IR-Runtime and I am connecting and verifying ok.

部署项目"坐在进行中"一段时间后由于超时而失败.当我同时使用SSMS和SSDT进行部署时，就会发生这种情况.我尝试重新启动ADF IR运行时，但无济于事.

The "Deploying Project" sits in "In Progress" for some time then fails due to timeout. This happens when I use both SSMS and SSDT to deploy.  I have tried restarting the ADF IR-Runtime, which doesn't help.

[等待操作超时]

[执行超时已过期.操作完成之前已经过了超时时间，或者服务器没有响应.]

[Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.]

[服务器名称:xxxxxxxxxxxxxxxxxx错误号:-2严重性:11状态:0]

[Server Name: xxxxxxxxxxxxxxxxxx Error Number: -2 Severity: 11 State: 0]

有没有人看到并解决了这个问题?

Has anyone seen and solved this?

推荐答案

ThomVF，

Hi ThomVF,

为确保涵盖所有步骤，请按照本教程进行操作: 将SQL Server Integration Services程序包部署到Azure

To ensure you have all the steps covered, please follow this tutorial: Deploy SQL Server Integration Services packages to Azure

这应该不会超过20分钟，但是，由于您已经部署了大多数(如果不是全部)，这应该是确保正确设置所有内容的一种方式.

It shouldn't take more than 20 mins but, since you have most (if not all) deployed already, this should be a way to ensure you have everything correctly set-up.

本教程:

This tutorial: Invoke an SSIS package using stored procedure activity in Azure Data Factory

涵盖了通过Azure门户以及通过PowerShell调用SSIS程序包的过程.它还概述了设置过程.

Covers the procedure for invoking the SSIS package through the Azure Portal as well as via PowerShell. It also outlines the set-up process. 

如果这些信息对您的问题有所帮助并带来了解决方案，请标记为已回答.

If this information is helpful to your issue and brings resolution, please mark this as being answered. 

此致

迈克

这篇关于在Azure SQL DB上将SSIS项目部署到SSISDB时超时的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！