This Video Tutorial illustrates how to use From Variable enumerator to loop through an array list. From Variable provides ability to loop through an array that filled from a script task. Collection structures such as Array and ArrayList can be loaded into an Object type variable in the SSIS package, and then Foreach Loop with Read more about Foreach Loop : From Variable Enumerator – SSIS 2012 Tutorial Videos[…]

This Video Tutorial illustrates how to use Nodelist enumerator to loop through an XML content with Foreach Loop structure. Nodelist uses XPath query language for interating through nodes, elements, attributes of an xml content, that might come from file, variable, or static string. In this sample we call a web service to select name of Read more about Foreach Loop : NodeList Enumerator – SSIS 2012 Tutorial Videos[…]