none
Does any one use Jenkins to deploy SSIS packages?

Answers

  • DTUTIL only copies the package. The config file you have to do it yourself.

    MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

    • Marked as answer by Eileen Zhao Monday, November 26, 2012 7:16 AM
    Tuesday, November 20, 2012 9:03 PM

All replies

  • Icerni,

    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 6:27 PM
    Moderator
  • A 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.

    lcerni

    Tuesday, November 20, 2012 7:39 PM
  • DTUTIL only copies the package. The config file you have to do it yourself.

    MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

    • Marked as answer by Eileen Zhao Monday, November 26, 2012 7:16 AM
    Tuesday, November 20, 2012 9:03 PM