What are DTS/SSIS in SQL Server? Do I need to separately install these services?
什么是SQL Server中的DTS / SSIS?我是否需要单独安装这些服务?
What is the use of this DTS/SSIS in SQL Server? How to configure DTS/SSIS?
在SQL Server中使用此DTS / SSIS有什么用?如何配置DTS / SSIS?
Help me in this regard please
请帮我这方面
Thanks in advance.
提前致谢。
3 个解决方案
#1
SSIS = SQL Server Integration Services. From Microsoft:
SSIS = SQL Server集成服务。来自微软:
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.
Microsoft Integration Services是一个用于构建企业级数据集成和数据转换解决方案的平台。您可以使用Integration Services通过复制或下载文件,发送电子邮件以响应事件,更新数据仓库,清理和挖掘数据以及管理SQL Server对象和数据来解决复杂的业务问题。这些软件包可以单独工作,也可以与其他软件包协同工作,以满Integration Services可以从各种来源(如XML数据文件,平面文件和关系数据源)中提取和转换数据,然后将数据加载到一个或多个目标中。 Integration Services包含一组丰富的内置任务和转换;用于构建包的工具;以及用于运行和管理包的Integration Services服务。您可以使用图形化Integration Services工具创建解决方案,而无需编写任何代码;或者,您可以对广泛的Integration Services对象模型进行编程,以编程方式创建包,并编写自定义任务和其他包对象的代码。
http://msdn.microsoft.com/en-us/library/ms141026.aspx
It's actually really cool stuff. Oracle has a pretty cool business intelligence editor for their dbms as well.
这真的很酷。 Oracle也为他们的dbms提供了一个非常酷的商业智能编辑器。
#2
On SSIS, take a look at this related question. I have posted useful links for SSIS on this question: What is the SSIS package and what does it do?
在SSIS上,看看这个相关的问题。我在这个问题上发布了SSIS的有用链接:什么是SSIS包,它做了什么?
#3
Check out this link : SSIS (SQL Server Integration Services) VS DTS (Data Transformation Services) : A basic overview
查看此链接:SSIS(SQL Server Integration Services)VS DTS(数据转换服务):基本概述
#1
SSIS = SQL Server Integration Services. From Microsoft:
SSIS = SQL Server集成服务。来自微软:
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.
Microsoft Integration Services是一个用于构建企业级数据集成和数据转换解决方案的平台。您可以使用Integration Services通过复制或下载文件,发送电子邮件以响应事件,更新数据仓库,清理和挖掘数据以及管理SQL Server对象和数据来解决复杂的业务问题。这些软件包可以单独工作,也可以与其他软件包协同工作,以满Integration Services可以从各种来源(如XML数据文件,平面文件和关系数据源)中提取和转换数据,然后将数据加载到一个或多个目标中。 Integration Services包含一组丰富的内置任务和转换;用于构建包的工具;以及用于运行和管理包的Integration Services服务。您可以使用图形化Integration Services工具创建解决方案,而无需编写任何代码;或者,您可以对广泛的Integration Services对象模型进行编程,以编程方式创建包,并编写自定义任务和其他包对象的代码。
http://msdn.microsoft.com/en-us/library/ms141026.aspx
It's actually really cool stuff. Oracle has a pretty cool business intelligence editor for their dbms as well.
这真的很酷。 Oracle也为他们的dbms提供了一个非常酷的商业智能编辑器。
#2
On SSIS, take a look at this related question. I have posted useful links for SSIS on this question: What is the SSIS package and what does it do?
在SSIS上,看看这个相关的问题。我在这个问题上发布了SSIS的有用链接:什么是SSIS包,它做了什么?
#3
Check out this link : SSIS (SQL Server Integration Services) VS DTS (Data Transformation Services) : A basic overview
查看此链接:SSIS(SQL Server Integration Services)VS DTS(数据转换服务):基本概述