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

  • 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

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

  • 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!

  • Cracking stuff Andy! Thanks for sharing.

  • 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?

  • 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