8 - SSIS: Extract data from a flat file to a data warehouse

This video shows a step by step on how to extract data from a flat file to a data warehouse.

SSIS is part of the Microsoft SQL Server data software, used for many data migration tasks. It is basically an ETL tool that is part of Microsoft's Business Intelligence Suite and is used mainly to achieve data integration. ... The data warehouse captures data from various sources for useful access and use.

Data Flow Task - Encapsulates the data flow engine that moves data between sources and destinations, and lets the user transform, clean, and modify data as it is moved.

Flat File Source - Reads data from a text file. The text file can be in delimited, fixed width, or mixed format.

OLE DB Destination - Loads data into a variety of OLE DB-compliant databases using a database table or view or an SQL command.

Visit my channel & Subscribe
See other step by step video series below: -

Introduction to SQL

Learn Microsoft Business Intelligence MSBI (SSIS, SSAS, SSRS) in just 10 minutes

Getting Started with Power BI

SSIS - Load data like an Expert (Update Existing Records and Insert New Records)

Power BI - Get Data from flat file (csv)

Microsoft Excel Dashboard