Home » SSIS-SQL Server Integration Services

SSIS-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

SSIS – Connection Managers

SSIS – Load flat file data into SQL Server Table

SSIS – Load Excel file data into SQL Server Table

SSIS – Derived Column Transformation

SSIS – Merge Transformations

SSIS – Conditional Split Transformations

SSIS – FTP task Send File to FTP Server

SSIS – FTP Task Send Multiple Files To FTP Server

         SSIS –  Aggregate Transformation Basic Mode

 

 658 total views,  7 views today