Script to create SSISDB folder

  • When deploying SSIS package to Integration Services Catalog (SSISDB), we need to have a folder created first, before we can create the Environments.

    I know the Environments can be scripted.

    Can the creation of the folder for SSISDB be scripted?

  • terry_stjean (4/7/2016)


    When deploying SSIS package to Integration Services Catalog (SSISDB), we need to have a folder created first, before we can create the Environments.

    I know the Environments can be scripted.

    Can the creation of the folder for SSISDB be scripted?

    It certainly can.

    There's a large collection of procs out of the box for working with SSISDB, and catalog.create_folder is just one of them.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • Thank you. will look into it.

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

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