ComCamp 2014; Presentation Files: Solution Architecture for Inferred Dimension Members with SSIS and MDS

Posted by on Mar 26, 2014 in ETL, MDS, Presentations, SSIS | No Comments

Thanks to all attendees of my session in ComCamp 2014 in Auckland about Solution Architecture for Inferred Dimension Members with SSIS and MDS. Here is session Title, Description, and presentation file; Title: Solution Architecture for Inferred Dimension Members with SSIS and MDS Description: Data Warehouses are heavily in use nowadays in most of businesses around ...

Read More

Presentation Materials: TechDays Hong Kong 2014, ETL Architecture for Solving Data Warehouse Challenges

Posted by on Mar 26, 2014 in ETL, MDS, Presentations, SSIS | No Comments

Thanks to all attendees of my session in TechDays 2014 Hong Kong about ETL Architecture for Solving Data Warehouse Challenges. Here is session Title, Description, and presentation file; Title: ETL Architecture for Solving Data Warehouse Challenges Description: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher ...

Read More

Error Handling in SSIS; Download presentation materials and recording

Posted by on Aug 22, 2013 in Presentations, SSIS | No Comments

Thanks for all attendees of today’s webinar about Error Handling in SSIS. turnout was good, and good questions asked and responded. Here are topics that covered in this session: Error handling in SSIS Data Taps Logging SSIS Catalog stored procedures for Logging and execution Debugging and Troubleshooting SSIS packages some live demos about error handling, ...

Read More

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