Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services Expand / Collapse
Author
Message
Posted Wednesday, June 19, 2013 12:04 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, December 24, 2015 7:14 AM
Points: 389, Visits: 1,070
Comments posted to this topic are about the item An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services

Andy Leonard
CSO, Linchpin People
Follow me on Twitter: @AndyLeonard
Post #1464952
Posted Wednesday, June 19, 2013 7:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 3, 2016 11:38 AM
Points: 1, Visits: 71
It was a good post. Thank you. Sorry I meant to give it 5 starts but somehow it ends just one
Post #1465151
Posted Wednesday, June 19, 2013 7:21 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 4, 2016 11:28 AM
Points: 117, Visits: 909
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
Post #1465155
Posted Wednesday, June 19, 2013 5:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 7, 2016 4:41 PM
Points: 18, Visits: 404
Thanks Andy. A very nice post.
Post #1465429
Posted Thursday, June 27, 2013 1:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 20, 2013 1:01 PM
Points: 1, Visits: 14
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());
Post #1468334
Posted Friday, November 6, 2015 12:45 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:00 PM
Points: 6,613, Visits: 16,138
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.



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

I had some words with my wife, and she had some paragraphs with me.
Post #1734275
Posted Monday, November 9, 2015 7:04 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, January 7, 2016 4:07 PM
Points: 6,265, Visits: 630
Excellent educational article, thank you.
Post #1734979
Posted Thursday, December 10, 2015 4:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, January 22, 2016 9:48 AM
Points: 2,714, Visits: 1,178
+1 from me. Great article, cheers.

qh


Who looks outside, dreams; who looks inside, awakes. – Carl Jung.
Post #1744185
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse