Post reply

An Overview of SSIS Variables – Step 13 of the Stairway to Integration Services

  • June 19, 2013 at 12:04 am

    #295461

    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

    #1625456

    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

    #1625460

    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

    #1625691

    Thanks Andy. A very nice post.

  • June 27, 2013 at 1:52 pm

    #1628120

    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

    #1838148

    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
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 9, 2015 at 7:04 am

    #1838543

    Excellent educational article, thank you.

  • December 10, 2015 at 4:54 am

    #1845150

    +1 from me. Great article, cheers.

    qh

    [font="Tahoma"]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply