Possible to call SSIS Environment Variable from stored proc?

  • 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?

  • 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]


  • 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