SQL Server Integration Services

最新推荐文章于 2024-07-20 17:52:29 发布

lliushanmei

最新推荐文章于 2024-07-20 17:52:29 发布

阅读量1.6k

点赞数

分类专栏： SSIS+SSAS+SSRS

SSIS+SSAS+SSRS 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

微软IS是建立企业级数据整合及转换的解决方案。你通过复制和下载文件，发送事件相应邮件，升级数据仓库，清理和挖掘数据，管理SQL Server对象和数据来使用IS解决复杂商业问题。其可以独立运行也可以与其他包无缝衔接以适应复杂商业需求。IS可以从多种资源中提取并转换数据，并将数据载入一个或多个目的地。

IS包括了丰富的内置任务和转换，打包工具，运行和管理包的服务，你可以使用图形IS工具界面来创造解决方案而不需要写一行代码，也可以为扩展IS对象模型编程来进行程序化建模，任务定制和创建其他包对象

https://docs.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-s

For content related to previous versions of SQL Server, see SQL Server Integration Services.

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. Integration Services 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 Services includes a rich set of built-in tasks and transformations; tools for constructing packages; and the Integration Services service for running and managing packages. You can use the graphical Integration Services tools to create solutions without writing a single line of code; or you can program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.