SQL Server Integration ServicesSQL Server Integration Services

APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

MicrosoftMicrosoft Integration ServicesIntegration Services 是用于生成企业级数据集成和数据转换解决方案的平台。Integration ServicesIntegration Services is a platform for building enterprise-level data integration and data transformations solutions. 使用 Integration ServicesIntegration Services 可解决复杂的业务问题,具体表现为:复制或下载文件,加载数据仓库,清除和挖掘数据以及管理 SQL ServerSQL Server 对象和数据。Use Integration ServicesIntegration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL ServerSQL Server objects and data.

Integration ServicesIntegration Services 可以提取和转换来自多种源(如 XML 数据文件、平面文件和关系数据源)的数据,然后将这些数据加载到一个或多个目标。can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

Integration ServicesIntegration Services 包括一组丰富的内置任务和转换,用于生成包的图形工具和可在其中存储、运行和管理包的 Integration ServicesIntegration Services 目录数据库。includes a rich set of built-in tasks and transformations, graphical tools for building packages, and the Integration ServicesIntegration Services Catalog database, where you store, run, and manage packages.

可以使用图形 Integration ServicesIntegration Services 工具来创建解决方案,而无需编写单行代码。You can use the graphical Integration ServicesIntegration Services tools to create solutions without writing a single line of code. 也可以编写广泛的 Integration ServicesIntegration Services 对象模型以编程方式创建包,并对自定义任务和其他包对象进行编码。You can also program the extensive Integration ServicesIntegration Services object model to create packages programmatically and code custom tasks and other package objects.

获取 SQL Server Integration ServicesGet SQL Server Integration Services

有关在 SQL Server 中安装 SQL Server Integration Services 以及其他可能想要或需要的下载信息,请参阅安装 Integration ServicesFor info about installing SQL Server Integration Services with SQL Server, and about additional downloads you may want or need, see Install Integration Services.

info_tip ResourcesResources