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: Today @ 6:49 PM
Points: 389, Visits: 1,042
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: 2 days ago @ 7:01 PM
Points: 1, Visits: 36
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: Wednesday, August 13, 2014 8:18 AM
Points: 110, Visits: 783
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: 2 days ago @ 1:38 AM
Points: 12, Visits: 353
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