SQL Server Integration Services

SQL Server Integration Services is a data migration and integration tool that can extract and transform data from a wide variety of sources such as flat files, and relational data sources, and then load the data into one or more destinations.

It includes various built-in tasks and transformations, graphical tools for building packages, and the Integration Services Catalog database, where you store, run, and manage packages.

Getting Started with SSIS

Create a New SSIS Project

Load flat file data into SQL Server Table

Load Excel file data into SQL Server Table

 

 

 44 total views,  5 views today