SSIS Tutorial 3: Understanding Basic SSIS Terminologies:Control Flow Tools, Data Flow Tools, Variables and Connection Managers.

I’m continuing with the basic terminologies to get us going into knowing the details of the SSIS tool in general. In the previous tutorial, I’ve introduce the interface of the SSIS platform. We discussed the control flow, data flow, event handlers and a package it self. As we saw in the last tutorial, the control flow is […]

Read More

SSIS Tutorial 2: Understanding Basic SSIS Terminologies: Package, Control flow, data flow, event handler and ETL

I’ve started talking about SSIS in the last tutorial and today, l’m moving forwared to introduce the Interface of the SSIS platform. Its very important to know the tool from outside before you start messing around with it. So, Lets go through some of the features on the interface as we  start to create our […]

Read More

SSIS Tutorial 1:Introduction.

I’ve been writing sometime now on Transact Sequel (TSQL) which is the microsoft version of SQL and I hope those posts help clarify some major tasks in SQL server programming. In this new tutorial which l’m starting today because of the numerous request that I’ve been getting to provide this lecture free online and due to my basic concept […]

Read More

TSQL Stored procedure to get factorial of a given number

This is one little stored procedure to get the factorial of a given number. Some of this little things make you very good in programming as you develop your logic building skills across different areas of computing. One important and good thing about programming is that, once you know the logic in accomplishing a task, […]

Read More