This Video Tutorial illustrates how to use ADO.NET Schema Rowset enumerator to loop through metadata information of a data source. ADO.NET Schema Rowset provides ability to loop through list of metadata and schema provided from a data source. For example when data source is SQL Server, the metadata will be fetched from INFORMATION SCHEMA views. Read more about Foreach Loop : ADO.NET Schema Rowset Enumerator – SSIS 2012 Tutorial Videos[…]

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[…]

This Video Tutorial starts with an introduction to Contianers in SSIS 2012, then it explains different kind of enumerators in foreach loop contianer. Finally this video will focus on File Enumerator, and shows an example of loading multiple CSV files into a destination table. In the example you will learn how to implement a loop Read more about Foreach Loop Container : File Enumerator – SSIS 2012 Tutorial Videos[…]