Flexible Source Locations - Level 16 of the Stairway to Integration Services

  • Andy Leonard

    SSChampion

    Points: 10023

    Comments posted to this topic are about the item Flexible Source Locations - Level 16 of the Stairway to Integration Services

    Andy Leonard, Chief Data Engineer, Enterprise Data & Analytics

  • Jo Pattyn

    SSC-Dedicated

    Points: 31393

    Thanks for the excellent stairway. Could you add level 15 and 16 to the general overview of stairway to ssis?

  • Nevyn

    SSChampion

    Points: 14210

    Ironically, I was about to create a package to do just this, and was thinking I'd need a script task to find all the csv's in a directory, and then I'd need a foreach to loop through the variable. Excellent timing, Mr Leonard!

  • Lempster

    SSCoach

    Points: 15651

    Cracking stuff Andy! Thanks for sharing.

  • jetboy2k

    Mr or Mrs. 500

    Points: 529

    One thing that isn't illustrated in this example is the actual mapping of variables to values in the container. In this instance, since there was only one variable (SourceFileName), and only value per loop to which that variable could map, that SSIS was able to map the two automatically.

    But what happens (or, possibly better phrased), what does it look like when I have multiple values and variables? How do I map Var1 to Val1 and Var2 to Val2?

  • sgeheeb

    Newbie

    Points: 2

    Yup, I have the same problem. Do we ever actually map the value returned by the loop to a variable? If it is done automatically, how would it handle multiple return values? Is this done via the Index of the variable?

Viewing 6 posts - 1 through 6 (of 6 total)

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