This project is read-only.

Set Variables when executing SSIS packages

Jan 16, 2015 at 5: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 9: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 9: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 1:09 PM
Edited Jan 16, 2015 at 2:48 PM
Could you give me some feedback with this build? https://ci.appveyor.com/project/CdricLCharlier/nbi/build/1.9.0.99028

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|http://nbi.codeplex.com/wikipage?title=Etl&referringTitle=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