how can i generate ssis packages from biml using commandline and deploy ssis on server

Question

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

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

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?

Answer 1

Automating the emission of SSIS packages from Biml is going to require access to the core bimlengine. Access to the biml engine comes via a licensed installation of Mist/soon-to-be-rebranded-BimlStudio

Conversion of a dtproj to ispac is going to require you to create and install an MSBuild extension which I cover in my talk, DevOps for SSIS The msbuild parameters and the process is outlined under Building SSIS 2012 using MSBuild – A Journey to DB deployment automation

Answer 2

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