Post reply

Possible to call SSIS Environment Variable from stored proc?

  • August 8, 2019 at 7:08 pm

    #3670023

    I'm using SSIS Catalog with an Environment, and it works great with packages. Is it possible to get the value of an environment variable from a stored procedure?

  • August 8, 2019 at 7:12 pm

    #3670026

    As long as it's not marked as 'sensitive'.

    Try running this in SSISDB as you'll see for yourself:

     

    SELECT * FROM [internal].[environment_variables]

  • August 8, 2019 at 7:17 pm

    #3670028

    Very cool, thanks!

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

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