Post reply

creating sql server agent job using SSISDB

  • April 4, 2018 at 1:01 am

    #410383

    We have deployed all the SSIS projects as a File System until now.

    All the SSIS projects/packages are protected using Encryptsensitivedatawithpassword option.

    So, while scheduling the Sql server agent job we use cmd exec type and use the call the commands with dtexec /f and then use /decrypt <pwd> while creating packages.

    Now we are planning to deploy the projects into SSISDB.

    I tried a test package converted it into Deployment model and then successfully deployed the project into SSISDB.
    But i need some help in scheduling the job from sql server agent.I nee to give decrypt password to make the package run successfully.

    So please guide me how to create the package by giving the decryption details.

    Thanks.

  • April 4, 2018 at 2:17 am

    #1985410

    When you deploy projects to the SSISDB the package, and projects are deployed unencrypted (well, they are still encrypted, but so that only SQL Server can read them). It tells you this when you're deploying. There is no need to supply a password; you simply select the appropriate package from the catalog.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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