This Video Tutorial illustrates how to use ADO enumerator to loop through a data table that loaded within the package. ADO Enumerator loops through a data table that loaded into an Object type variable. The object type variable can be filled with a data table through an Execute SQL Task with a Full Result Set, Read more about Foreach Loop : ADO Enumerator – SSIS 2012 Tutorial Videos[…]
This Video Tutorial illustrates how to use Item enumerator to loop through a pre-defined data table. A data table with multiple columns can be defined in the Item Enumerator, data type of columns can be different. Item Enumerator then will loops through each record, pick each column value and insert that into package variable. In Read more about Foreach Loop : Item Enumerator – SSIS 2012 Tutorial Videos[…]
This Video Tutorial illustrates how to use SMO enumerator to loop through linked servers. SMO stands for SQL Server Management Objects, and using SMO provides ability to loop through list of metadata objects of SQL Server database or instance. This enumerator can be used for looping through jobs, linked servers, data files of database, and Read more about Foreach Loop : SMO Enumerator – SSIS 2012 Tutorial Videos[…]
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[…]
I am delighted to say that I will speak at this year’s Pass Summit 2013 in NC Charlotte. Session that I will speak on it is: SSIS Package Failed in Production? Here’s How to Troubleshoot This will be my first attendance in Pass Summit and I am looking forward to see many of you, and Read more about I am speaking at Pass Summit 2013[…]
Last week I’ve talked with Greg Low from SQL Down Under, and Greg published the podcast talk in his website. I really appreciate Greg’s idea an hard work on podcast shows series on his website. I enjoyed when I read podcasts from many SQL Server MVPs about their area of expertise. I strongly recommend to Read more about SQL Down Under Pod Cast[…]
I’ve created another video of SSIS 2012 Tutorial Videos series. In this video samples of Execute Process Task illustrated. Execute Process Task provide ability to run executable files from SSIS package. In this Video there are two samples of working with Execute Process Task: Compressing Files (Archiving) into zip files formatted with date and Read more about Execute Process Task – SSIS 2012 Tutorial Videos[…]