SSIS Tutorial - Import and Export Wizard

Опубликовано: 19 Апрель 2017
на канале: BeardedDev

9,038

This video will teach you how to import and export data with examples, in Microsoft SQL Server, we also look the capabilities of the SSIS Import and Wizard.

Examples:
How to import data in to the database from Microsoft Excel and create a destination table
How to export data using a SQL query and create a destination flat file (CSV).

SSIS Import and Wizard is a great tool to perform Extract and Load tasks.

Import and Export Wizard:
Can perform simple data movements (simplified ETL process without the T)
Can save packages to be reused or edit as needed in SSDT
Can create destination tables or files
Can write a query to filter data we are transferring
Can perform basic data transformations
Beware of warnings: Truncation can occur

SELECT O_Date, P_Title, P_BarCode, DATEDIFF(DD, O_Date, CURRENT_TIMESTAMP) AS [Days_Since_Purchase] FROM Customers
INNER JOIN Orders ON C_Id = O_C_Id
INNER JOIN Order_Details ON O_Id = OD_O_Id
INNER JOIN Books ON OD_P_Id = P_Id
WHERE C_Id = 2

Steps performed:
Choose a data source
Choose a destination
Specify table copy or query
Select source tables and views
Save and run package