I have a SSIS Solution built in Visual Studio Community 2019 using SSDT. The solution contains about 15 packages. I am using 5 variables (created in the first package) that I would like to use in all of the other packages. Is there a way to make a variable usable in other packages within the same solution?
No. Only parameters can be shared, and only within a project (not across a solution).
November 25, 2019 at 7:29 pm
Okay, thanks.
November 26, 2019 at 1:51 pm
Just to elaborate, if you set up the other packages to run within a master package, you can then pass the variables that way. If you're using SQL Server 2012 or higher, it's easy to do. I pass many variables that have been determined by the master package to the child packages. The master child package setup is considered a best practice approach.
November 26, 2019 at 2:18 pm
Just to elaborate, if you set up the other packages to run within a master package, you can then pass the variables that way. If you're using SQL Server 2012 or higher, it's easy to do. I pass many variables that have been determined by the master package to the child packages. The master child package setup is considered a best practice approach.
You can pass (master) variables to (child) parameters, but you cannot pass variables to variables.
November 26, 2019 at 2:40 pm
Agreed. Thanks for clarifying. My use of the terminology was imprecise. I'll correct the answer later.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy