- SQL Server Data Tools 2015(install a shell of Visual Studio 2015)
- Visual Studio 2015
What is SSIS?
SSIS stands for SQL Server Intergration Services. SSIS is to do the ETL(Extract, Transform and Load) task for data warehouse.
SSIS can also update data warehouse, clean and mine data, create ‘packages’, manipulate data, etc.
To design ETL task in Visual Studio, we use the data flow in Visual Studio.
What is data flow?
A data flow defines a flow of data from a source to a destination.
Before designing the data flow, we can try to drag a data flow and drop it in the control flow.
What is a control flow?
It is a flow we can use to control the flow for different tasks. It provides the logic for when data flow components are run and how they run.
- perform lopping
- call stored procedures
- move files
- manage error handling
- check a condition and call different tasks
It defines a workflow of tasks to be executed, often a particular order (assuming your included precedence constraints).
we can rename the data flow task in control flow.
For example, we can drag OLE DB Source, so we can connect to Relational Database.
Then we can follow the Microsoft official toturial to do it step by step.
If you are interested in or have any problems with SSIS, feel free to contact me.
Or you can connect with me through my LinkedIn.