March 1, 2013 at 2:33 am
I am currently working on an SSIS solution which employs a parent child design pattern. There is a Sql table which contains field that determine what packages should run. Currently I use a SQL task to load values into a ADO recordset and the use a foereach loop container to loop through the record set and execute the necessary package within the ForEach container.
I vaguely remember reading somewhere online (can't remember now) where it was suggested that you could use a project parameter to store the values as opposed to an Sql table. For example you could declare a project parameter as a string with a value like: value1;value2;value3;value4. I think you could then split the string based on the semi-colon separator. With the value split you can then use the Foreach loop container to loop through the values.
I find this solution much better as I can keep functionality within the SSIS framework. My question is how do you it? How can I split the project parameter and then pass the values to a ForEach container such that it can loop through the split values.
March 2, 2013 at 2:09 am
I mananged to solve it b creating a script task and splitting the parameter into an array and loading the array into an object variable. Then using th ForLoop to loop through th object.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply