e
q
u
e
s
t
a
d
e
m
o < back
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
Old blog from Matt Masson