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: Tuesday, May 17, 2016 7:36 AM
Points: 390, Visits: 1,079
Comments posted to this topic are about the item An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services

Andy Leonard
Data Philosopher, Enterprise Data & Analytics
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: Thursday, March 17, 2016 1:42 PM
Points: 1, Visits: 73
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: Monday, April 11, 2016 5:50 AM
Points: 117, Visits: 924
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 @ 11:52 PM
Points: 7,078, Visits: 17,179
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.

Never attribute to malice that which is adequately explained by stupidity
Post #1734275
Posted Monday, November 9, 2015 7:04 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:47 AM
Points: 7,809, Visits: 740
Excellent educational article, thank you.
Post #1734979
Posted Thursday, December 10, 2015 4:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:56 AM
Points: 2,719, Visits: 1,199
+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