SQL Server Integration Services
E56984
SQL Server Integration Services is a Microsoft ETL and data integration platform used to extract, transform, and load data between diverse sources within the SQL Server ecosystem.
Aliases (2)
- SSIS ×1
- SSIS pipeline engine ×1
Statements (79)
| Predicate | Object |
|---|---|
| instanceOf |
ETL tool
→
Microsoft software product → data integration platform → |
| abbreviation |
SSIS
→
|
| developer |
Microsoft
→
|
| hasComponent |
Control Flow
→
Data Flow → Event Handlers → Integration Services service → Package Explorer → SSIS Catalog → SSIS pipeline engine → SSIS runtime engine → SSISDB database → |
| includedWith |
SQL Server Enterprise Edition
→
SQL Server Standard Edition → |
| introducedIn |
SQL Server 2005
→
|
| licenseModel |
proprietary
→
|
| partOf |
Microsoft SQL Server
→
|
| primaryLanguage |
C# (for Script Task and Script Component)
→
VB.NET (for Script Task and Script Component) → |
| replaced |
Data Transformation Services
→
|
| runsOn |
Windows
→
|
| supportsDeployment |
Azure-SSIS Integration Runtime in Azure Data Factory
→
on-premises SQL Server → |
| supportsDestination |
ADO.NET destinations
→
Excel files → ODBC destinations → OLE DB destinations → SQL Server Analysis Services → SQL Server relational databases → flat files → raw files → |
| supportsFunction |
bulk data loading
→
change data capture integration → checkpoint restartability → control flow management → data cleansing → data encryption in transit → data flow transformations → data integration → data migration → data profiling → data warehousing ETL → deployment to SSIS Catalog → environment-specific configurations → error handling and logging → event handling → extract data → file system operations → incremental data loading → load data → logging to multiple targets → lookup operations → message queue integration → package configuration → package deployment model → parallel task execution → parameterized execution → project deployment model → scheduling via SQL Server Agent → script-based transformations → slowly changing dimension handling → transform data → versioning of packages in catalog → workflow orchestration → |
| supportsSecurityFeature |
SQL Server Authentication
→
Windows Authentication → credential-based connections → package protection levels → |
| supportsSource |
ADO.NET data sources
→
Excel files → ODBC data sources → OLE DB data sources → SQL Server relational databases → XML files → flat files → |
| usesIDE |
SQL Server Data Tools
→
Visual Studio (via SSDT) → |
Referenced by (6)
| Subject (surface form when different) | Predicate |
|---|---|
|
SQL Server
→
SQL Server Integration Services ("SSIS pipeline engine") → |
hasComponent |
|
Data Quality Services
→
Master Data Services → |
integratesWith |
|
SQL Server Integration Services
("SSIS")
→
|
abbreviation |
|
Developer Edition
→
|
supports |