SSIS Integration Services features supported by the editions of SQL Server (不同SQL Server版本SSIS支援的功能)

1.Standard Edition就有SSIS所有標準功能

2.Enterprise Edition的SSIS含有以下進階功能

(1)Integration Services - Advanced sources and destinations

• High-performance Oracle source and destination by Attunity
• High-performance Teradata source and destination by Attunity
• SAP BW source and destination
• Data mining model training destination
• Dimension processing destination
• Partition processing destination

(2)Integration Services - Advanced tasks and transformations

• Change Data Capture components by Attunity
• Data mining query transformation
• Fuzzy grouping and fuzzy lookup transformations
• Term extraction and term lookup transformations

(3)Scale Out Master

Integration Services features supported by the editions of SQL Server

https://docs.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server?view=sql-server-ver15