SSIS HELP

{TOC}

IMPORTANT FOR DATA MASKING SSIS FEATURES

Sources

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

Files

TEXT

Databases

SSIS 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

USEFUL SITES AND BLOGS

Help from Microsoft:

https://technet.microsoft.com/en-us/library/bb522537(v=sql.100).aspx

New blog with Jimmy Wong

http://blogs.msdn.com/b/ssis/

Old blog from Matt Masson

http://blogs.msdn.com/b/mattm/