July 26, 2010 at 8:24 am
For Input files which are dynamic, rather than using the Variable option, is there a way to store the details in a table, so that when the pkg runs it gets it from the table all the details
July 27, 2010 at 3:16 am
In the control flow, execute an sp or some sql to get the asign the results to a result set (Object variable) then use a ForEach Loop Container.
You will still need some variables to hold the file path & file name which are returned from the container though.
July 30, 2010 at 9:50 am
You will definitely need to use variables but as the previous poster indicated, there is a way to assign the value of the variables at run time from a table if desired.
Another option for assigning the variables is the Script Task (if you are comfortable with Visual C# 2008 or Visual Basic 2008). In VB you use "Dts.Variables("VarName").Value" to reference or assign SSIS variable values.
Steve
August 2, 2010 at 3:53 am
balasach82 (7/26/2010)
For Input files which are dynamic, rather than using the Variable option, is there a way to store the details in a table, so that when the pkg runs it gets it from the table all the details
Help me understand...you will table scan that's fine...but where do you intend to store a value that the scan will return...:Whistling: :Whistling: :Whistling:
Raunak J
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply