我如何使用命令行从biml生成sis软件包并将sis部署在服务器上 [英] how can i generate ssis packages from biml using commandline and deploy ssis on server

问题描述

我致力于创建biml.从中生成ssis包.构建SSIS项目，然后在服务器上部署ispac文件.

I worked on creating biml. generate ssis packages from that. build SSIS project and then deploy ispac file on server.

但是所有这些手动步骤都可以自动化吗? 我可以使用命令行从biml生成ssis吗?除了bidshelper以外，什么是命令以及要在计算机上安装的前提条件是什么

but can these all manual steps be automated? can i generate ssis from biml using commandline? what are the commands and what are the prerequisites to be installed on machine for this other than bidshelper

之后，我可以构建具有从biml生成的ssis的集成服务项目，并使用命令行将其部署在服务器上吗?再次是什么先决条件.需要为此安装吗?

after that can i build my integration services project having ssis generated from biml and deploy it on server using commandline? again what are the pre-req. required to be installed for this?

推荐答案

下面的命令可以从biml生成ispac文件

below command after installing Mist 4.0 worked to generate ispac file from biml

bimlc.exe -s "C:\\temp\\Project.biml" -s "C:\\temp\\DwToDw.biml" -t "C:\\temp\\ispacfile\\" -v=2014 --ssisDeploymentModel=Project

这篇关于我如何使用命令行从biml生成sis软件包并将sis部署在服务器上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！