什么是 SSIS 包,它有什么作用? [英] What is the SSIS package and what does it do?

查看:51
本文介绍了什么是 SSIS 包,它有什么作用?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

谁能告诉我 SSIS 包是什么?

Can someone tell me what the SSIS package is all about?

我对数据仓库完全陌生,我对 SSIS、DTL、ETL 等术语很着迷.我正在寻找一个大图,以及它如何适应整个 .NET/SQL Server 架构.

I am totally new to data-warehousing and I am going crazy with the terms SSIS, DTL, ETL and so on. I am looking for a big picture and how it fits in the overall .NET/SQL Server architecture.

推荐答案

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

For Latest Info About SSIS > https://docs.microsoft.com/en-us/sql/integration-services/sql-server-integration-services

来自上面引用的站点:

Microsoft 集成服务是一个用于构建企业级数据集成和数据转换解决方案.使用集成服务通过复制解决复杂的业务问题或下载文件、加载数据仓库、清理和挖掘数据,以及管理 SQL Server 对象和数据.

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.

集成服务可以从广泛的数据中提取和转换数据各种来源,如 XML 数据文件、平面文件和关系数据源,然后将数据加载到一个或多个目的地.

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 Catalog 数据库,您可以在其中存储、运行和管理包.

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

如果您是集成服务信息工作者 - 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

这篇关于什么是 SSIS 包,它有什么作用?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆