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]

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • August 8, 2019 at 7:17 pm

    #3670028

    Very cool, thanks!

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

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