Skip to content
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 Transformation

SSIS – Conditional Split Transformations

SSIS – FTP task Send File to FTP Server

SSIS – FTP Task Send Multiple Files To FTP Server

SSIS – Load multiples .txt or .Csv files to SQL table

         SSIS –  Aggregate Transformation Basic Mode

SSIS – Copy column Transformation

SSIS – Row Count transformation 

SSIS – SSIS Toolbox is not showing

 

 3,347 total views,  2 views today