Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators

Posted by on Jul 24, 2013 in Presentations, SSIS | No Comments

Thanks for attending in my session at Pass DWBIVC today, it was my pleasure to see you there. Today’s talk was about; Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators in SSIS Session description: Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting ...

Read More

PIVOT Transformation Issue in SSIS

Posted by on Jul 23, 2013 in SSIS | No Comments

Today I’ve found a bug in SSIS Pivot Transform component reported as a question in TechNet forums here. Reported issue was related to pivoting some records based, result of PIVOT transformation in SSIS was not as expected to be. read below for detailed explanation; Scenario Explanation: This is a sample of incoming data set: The ...

Read More

Foreach Loop Enumerators in SSIS; My presentation on NetCom Learning

Posted by on Jul 18, 2013 in Presentations, SSIS | No Comments

Thanks for all who attended on my presentation today supported by Netcom Learning. http://www.netcomlearning.com/webinars/886622/Free-Webinar-Foreach-Loop-Enumerators-in-SSIS–SQL-Server-2012-training.html?WebinarID=205 Today’s presentation was a webinar on Foreach Loop Enumerators in SSIS. In this session I explained 7 different types of enumerators in SSIS; From Variable Enumerator File Enumerator Item Enumerator ADO Enumerator ADO.NET Schema Rowset Enumerator Nodelist Enumerator SMO Enumerator In ...

Read More

For Loop Container – SSIS 2012 Tutorial Videos

Posted by on Jul 16, 2013 in SSIS, SSIS Tutorial Videos | No Comments

This Video Tutorial illustrates how to use For Loop Container to implement a simple loop structure. For Loop Continaer provides a simple loop structure such as programming languages. It contains Init Expression, Eval Expreseeion, and Assign Expression. These three expressions makes the three main part of loop structure in programming languages as well, InitExpression is ...

Read More

Foreach Loop : ADO.NET Schema Rowset Enumerator – SSIS 2012 Tutorial Videos

Posted by on Jul 7, 2013 in SSIS, SSIS Tutorial Videos | No Comments

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