如何从 SSISDB 编写已部署的 SSIS 项目的脚本 - SqlServer 2012 [英] How to script an already deployed SSIS project from SSISDB - SqlServer 2012

问题描述

我想知道，对于已经部署的 SSIS 项目，从 SSISDB-Sql Server 2012，我是否可以编写孔包及其所有参数、连接管理器、引用等所有内容?我已经部署了一个 SSIS 项目，但我必须使用脚本将其部署到其他一些数据库，我想编写所有项目参数的脚本.

I want to know if, for an already deployed SSIS project, from SSISDB-Sql Server 2012, I can script the hole package, with all its parameters, connection managers, references, everything? I have an already deployed SSIS project but I must deploy it using scripts to some other database and I would like to script all project parameters.

问候，

推荐答案

您可以从 SQL Server Management Studio 将整个 SSIS 项目从 SSISDB 导出为 .ispac 文件；只需从上下文菜单中选择项目和导出....但是，此文件将仅包含项目及其参数、连接管理器和包；您可以将其部署在另一台服务器上，无需参考和环境.

You can export whole SSIS project from SSISDB as an .ispac file from SQL Server Management Studio; just select project and Export... from context menu. However, this file will contain only project with its parameters, connection managers and packages; you can deploy it on another server without references and environments.

您无法使用 SSMS 从 SSISDB 导出引用和环境.有 一篇优秀文章脚本 示例.脚本生成一组 t-sql 命令，重新创建环境及其与项目的引用.

You cannot export referencies and environments from SSISDB with SSMS. There is an excellent article with script sample. Script generates a set of t-sql commands recreating environment and its references with project.

结合这两种方法你就大功告成了.

Combining these two approaches you will be done.

这篇关于如何从 SSISDB 编写已部署的 SSIS 项目的脚本 - SqlServer 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！