Tuesday, November 20, 2012 6:15 PMDoes any one use Jenkins to deploy SSIS packages?
Tuesday, November 20, 2012 6:27 PMModerator
Jenkins can execute bat files, right?
Then you sure can
Either Dtutil is necessary and there is no workaround or the manifest would be run in non-interactive mode
Can I know why you are asking? Do you have any concerns?
I would say just go experiment and share your findings here.
Arthur My Blog
Tuesday, November 20, 2012 7:39 PMA new manager wants us to take this approach. My only concern is the config file. The last manager has us use the SSISDeploy.SSISDeploymentManifest, FileNameHere.dtsx, and FileNameHere.dtsConfig files to deploy to an instance. I was reading about the DTUTIL. It looks like this utility would move the dtsx file to the msdb database. I am guessing I would have to create a bat file to move the config file to the proper directory. I don't think the DTUTIL utility would move the config file. Am I correct? I am guessing the the SSISDeploymentManifest is sort of like the DTUTIL utility moving both the dtsx file and the config file. But the DTUTIL utility only moves the dtsx file.
Tuesday, November 20, 2012 9:03 PMDTUTIL only copies the package. The config file you have to do it yourself.
- Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Monday, November 26, 2012 7:16 AM