Global Variables in SSIS

Question

Global Variables in SSIS

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

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

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

Not really. You might consider creating a physical 'Variables' table in SQL Server and using that to store/lookup any variables which are truly global.

Phil

pshvets SSCommitted Points: 1850 More actions · Answer 2

Thanks a lot for reply.

Creating a table for global variables was my last resort. 🙂

Phil Parkin SSC Guru Points: 247183 More actions · Answer 3

For one solitary piece of data it's certainly a pain - but if you are generic about how you write it you will be able to reuse in future.

Phil