How to create SSISDeploymentManifest via command line

As part of my automatic build, I need to have a few artifacts to deploy. One of them is the SSISDeploymentManifest file created when I created my SSIS project in Visual Studio 2008 (VS 2010 does not support SSIS / BIDS).

I am trying to find a way to do this from the command line, but the normal stuff is not working (devenv with the flags / Build and / Project ...)

Does anyone know how to do this?

NOTE. I am using TFS 2010 to create

OTHER NOTE: I am NOT trying to deploy or run an SSIS package. I just need an SSISDeploymentManifest file created in such a way that when someone "blesses" the assembly, it can be easily deployed. (This means that dtutil and DTEXEC are not what I'm looking for.)

+4
source share
1 answer

I don’t know if you could find a way around this. I tried to do the same and run into the same old "Oh, but you should use xyz instead of" answers that don't help. In the end, I simply created a deployment manifest using BIDS and then copied it to the solution directory. It never changes (at least for our packages it’s not), and since the build command does not actually do more than copy the dtsx and config file to a folder and write xml for the deployment manifest, it makes sense to just ask my the build process is to copy these files, including my previously created manifest.

It also allowed me to edit confidential information (i.e. the name of my domain account and the domain name itself) from the manifest file. The only thing is if you significantly change your package (for example, renaming it), you will need to create a new manifest using BIDS, but this is the best I could come up with, and I could not justify more time spent searching differently.

0
source

Source: https://habr.com/ru/post/1396950/


All Articles