Post reply

How to set target for deploying package in folder under msdb

  • May 2, 2011 at 8:09 am

    #238934

    Hello fellow SSIS geeks.

    I've got some packages that I've set up msdb, under subfolders so we can organize by project. Up to this point, we've always done the import thing to get them between servers, but now I'm finally getting some time to set up package configurations. This of course, means I have to use the deploy method. Got the first one ready to go, but can't get it to target my subfolder to replace what I've already got out there. Get prompted for locations for supporting files when I install, but don't get prompted for the package path.

    I've looked through the properties in BIDs, both the package and the project, and not finding a place to set this. Anybody solved this one already?

    Brenda

  • May 3, 2011 at 1:01 pm

    #1319337

    How exactly are you deploying?

    I would use the dtutil command line utility. Script some commands out in a .bat file.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 4, 2011 at 5:25 am

    #1319650

    Koen,

    thanks for the idea, I'll check into it. I was just clicking on the manifest file to run the package install wizard.

    I realized that if I didn't have any support files to move, I really don't need to use the deploy feature, I can do the "save copy of" to put it on the server where I want.

    I thought if I was using package configurations, the only way they'd work was by deploying the package, but with me storing all the package configurations in the db, it doesn't include them in the deploy package anyway. Thank goodness for Red Gate tools - used them to sync my package settings between dev, test, and production. Then all I had to do was set the one variable with the servername\instance to run against in the Set Values tab on the job, and I was good to go. Interesting how all the books I went through, none of them actually had the steps you need to use sql to hold your package configurations & deploy them.

    Brenda

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply