Monday, January 25, 2010
The use of object varaibles, resultset and foreach loop in SSIS
I've recently been involved in documenting an SSIS package made by our lead developer and there is a foreach loop that he used to loop through a resultest from a query. An object variable is used to hold the resultset temporarily and the foreach loops through this result to repeat some actions. Since this trick is pretty new to me, I hence document a very good tutorial here to keep a memo.
Labels:
foreach,
object variable,
resultset,
SSIS
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment