Possible to call SSIS Environment Variable from stored proc?

Question

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

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

Phil Parkin SSC Guru Points: 246987 More actions · Answer 1

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

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Rekonn SSChasing Mays Points: 619 More actions · Answer 2

SSChasing Mays

Points: 619

August 8, 2019 at 7:17 pm

Very cool, thanks!