SSIS HELP

{TOC}

Sources

TEXTSources in SSIS are components that allow to connect to a data source, be it a database, a file, or a service.

Files

TEXT

Databases

TEXTSSIS connect to any database that support the following drivers: ODBC, OLE DB, ADO.NET, ADO, and SQL Server Native Driver. Relational Data Management Systems with such connectivity include well known vendors ( Oracle's Oracle and MySQL databases, Microsoft's SQL Server, Access, and SQL Server in Azure, Sybase, IBM's database varieties, and not so well known such as Postgres, Ingres, SQL Lite, etc.)

Services

TEXT

Components Editor

TEXT

Destinations

TEXT

Files

TEXT

Databases

TEXT

Services

TEXT

Error Handling

TEXT

Auditing

TEXT

Log

TEXT

Count Component

TEXT

SSIS “Native” Data Masking Components

TEXT

Derived Column

TEXT

Divide and Concur

TEXT