使用TFS命令行部署SSIS项目 [英] Deploy SSIS Project using TFS Command Line

问题描述

如何从TFS 2015部署SSIS项目?

对于常规数据库项目，它是具有发布配置文件的 sqlpackage.exe/publish .

将SSIS项目模型自动部署到服务器中的命令行参数是什么?

我们正在使用SQL Server 2016 Enterprise.

解决方案

为什么使用

您仅需在静默模式下使用 IsDeploymentWizard 即可阻止显示向导，但是您应指定所需的参数.

  ISDeploymentWizard/S/SP:foo.ispac/DS:myserver/DP:/ssisdb/test/test 

程序的GUI版本提供了为ISDeploymentWizard构建初始参数的快捷方式.在确认屏幕中，您将看到类似以下的图像

请注意命令行"部分-这些是自动部署需要传递的参数(如果选择Ctrl-C，则会复制整行)

参考文献和有用的链接

• Project&程序包部署方法– SSIS基础
• 我可以使SSIS项目部署自动化吗?/a>
• dtutil实用程序 (单个程序包部署工具)
• SSIS构建和升级；部署

How do I deploy an SSIS project from TFS 2015?

For regular database projects, it is sqlpackage.exe /publish with publish profile.

What is the command line argument to auto deploy SSIS Project Model into a server?

We are using SQL Server 2016 Enterprise.

解决方案

Why using runas command??

Runas command allows a user to run specific tools and programs with different permissions than the user's current logon provides.

Based on Deploy an SSIS project from the command prompt with ISDeploymentWizard.exe::

If you're deploying to a SQL Server with the Deployment Wizard, you have to use Windows authentication; you can't use SQL Server authentication.

Then if the current user has access to the remote server you don't need to use runas command then no need to provide a password.

---

How to use IsDeploymentWizard to automate ssis project (.ispac) deployment?

First of all, run ISDeploymentWizard.exe /? from a command prompt, and you’ll see the full list of arguments it supports with their abbreviations.

You only have to use IsDeploymentWizard in silent mode to prevent showing the wizard, but you should specify the argument needed.

ISDeploymentWizard /S /SP:foo.ispac /DS:myserver /DP:/ssisdb/test/test 

A shortcut to building the initial arguments for the ISDeploymentWizard is provided by the GUI version of the program. In the confirmation screen, you would see an image like the following

Note the Command Line section - those are the arguments you will need to pass for an automated deployment (Ctrl-C will copy that entire line if you select it)

References & Helpful Links

• Project & Package Deployment Methods – SSIS Basics
• Can I Automate SSIS Project Deployment?
• ISDeploymentWizard switch
• dtutil Utility (single package deployment tool)
• SSIS Build & Deploy

这篇关于使用TFS命令行部署SSIS项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！