Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Does any one use Jenkins to deploy SSIS packages?

Answered Does any one use Jenkins to deploy SSIS packages?

  • Tuesday, November 20, 2012 6:15 PM
     
     
    Sign In to Vote
    0
    Does any one use Jenkins to deploy SSIS packages?

    lcerni

     

All Replies

  • Tuesday, November 20, 2012 6:27 PM
    Moderator
     
     
    Sign In to Vote
    0

    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 7:39 PM
     
     
    Sign In to Vote
    0
    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 9:03 PM
     
     Answered
    Sign In to Vote
    0
    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.