Set Variables when executing SSIS packages

Jan 16, 2015 at 4:48 AM
I have a few old SSIS packages that I want to use to setup some tests. As far as I can tell, only parameters are supported.

Are there any plans on adding support for variables in the future?
Jan 16, 2015 at 8:51 AM
I'll take a look to this and decide if I could include this in the next release or the release after (depending on complexity of testing this).
Jan 16, 2015 at 8:52 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Jan 16, 2015 at 12:09 PM
Edited Jan 16, 2015 at 1:48 PM
Could you give me some feedback with this build?

In the definition of your test: define your variable as a parameter
<parameter name="User::xxx">VARIABLE_VALUE</parameter>
Note that it will only work if you define your package as a DTS package (so not a Catalog package) ==> Hosted on a file folder or Hosted on SQL Server but not Hosted on SQL Server (SSIS Catalog). See [url:documentation|] for more information about these concepts.

Tell me if it works for you or not.
Marked as answer by Seddryck on 2/12/2015 at 1:36 PM