ssis - 什么是 SSIS 包以及它的作用是什么？

Question

有人可以告诉我 SSIS 包的全部内容吗？

我对数据仓库完全陌生，并且对 SSIS、DTL、ETL 等术语感到非常着迷。我正在寻找一个大局以及它如何适应整个 .NET/SQL Server 架构。

Answer 1

有关 SSIS 的最新信息 > https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services

来自上面引用的网站:

Microsoft Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data.

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, graphical tools for building packages, and the Integration Services Catalog database, where you store, run, and manage packages.

You can use the graphical Integration Services tools to create solutions without writing a single line of code. You can also program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.

SSIS 入门 - http://msdn.microsoft.com/en-us/sqlserver/bb671393.aspx

如果您是集成服务信息 worker - http://msdn.microsoft.com/en-us/library/ms141667.aspx

如果您是集成服务管理员 - http://msdn.microsoft.com/en-us/library/ms137815.aspx

如果您是集成服务开发人员 - http://msdn.microsoft.com/en-us/library/ms137709.aspx

如果您是集成服务架构师 - http://msdn.microsoft.com/en-us/library/ms142161.aspx

SSIS 概述 - http://msdn.microsoft.com/en-us/library/ms141263.aspx

集成服务操作方法主题 - http://msdn.microsoft.com/en-us/library/ms141767.aspx