June 19, 2013 at 12:04 am
Comments posted to this topic are about the item An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services
Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics
June 19, 2013 at 7:18 am
It was a good post. Thank you. Sorry I meant to give it 5 starts but somehow it ends just one
June 19, 2013 at 7:21 am
Andy,
I agree with you on the "scoping" of variables. Has anybody EVER come up with a good use case for the scope of variables? I think that MS would have been better off removing this "feature" altogether, although making project the default scope is a good start.
Nice article.
Regards,
Tom
June 19, 2013 at 5:37 pm
Thanks Andy. A very nice post.
June 27, 2013 at 1:52 pm
I am inexperienced with c#, I had to use the following in place of your example to get mine to work after editing script:
MessageBox.Show(Dts.Variables["User::MyVariable"].Value.ToString());
November 6, 2015 at 12:45 am
Nice article, Andy.
I assume that you will be adding some parameters to your 'variables and parameters' package in a later article?
Building variable expressions which use the values of parameters passed in from SSISDB environments is something I do all the time, and a useful technique, so I hope you will be covering that too.
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
November 9, 2015 at 7:04 am
Excellent educational article, thank you.
December 10, 2015 at 4:54 am
+1 from me. Great article, cheers.
qh
Viewing 8 posts - 1 through 7 (of 7 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