Search code examples
ssisautomationbiml

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

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?

Solution

  • 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