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

  • Andy Leonard

    SSCrazy Eights

    Points: 9865

    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

  • lizli427

    Valued Member

    Points: 51

    It was a good post. Thank you. Sorry I meant to give it 5 starts but somehow it ends just one 🙁

  • Tom Bakerman

    Hall of Fame

    Points: 3367

    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

  • Patrick Ge

    SSC Eights!

    Points: 912

    Thanks Andy. A very nice post.

  • alinafe.matenda

    Valued Member

    Points: 57

    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());

  • Phil Parkin

    SSC Guru

    Points: 243541

    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.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Excellent educational article, thank you.

  • quackhandle1975

    SSChampion

    Points: 10963

    +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 8 (of 8 total)

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