February 26, 2014 at 12:08 am
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
February 26, 2014 at 2:05 am
Thanks for the excellent stairway. Could you add level 15 and 16 to the general overview of stairway to ssis?
February 26, 2014 at 6:58 am
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!
February 27, 2014 at 5:02 am
Cracking stuff Andy! Thanks for sharing.
March 25, 2017 at 12:53 pm
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?
April 29, 2020 at 8:12 am
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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply