Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Saturday, March 7, 2015 6:36 AM
Points: 388, Visits: 1,056
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: Tuesday, January 20, 2015 6:47 AM
Points: 1, Visits: 46
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: Today @ 7:21 AM
Points: 116, Visits: 840
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: Wednesday, March 25, 2015 3:08 PM
Points: 12, Visits: 381
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse