Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SSIS(Sql Server Integration Services)
08-01-2016, 09:52 AM (This post was last modified: 07-11-2018 01:55 PM by xwcwt.)
Post: #1
SSIS(Sql Server Integration Services)
"SSIS(Sql Server Integration Services)是用于生成企业级数据集成和数据转换解决方案的平台。使用 Integration Services 可解决复杂的业务问题,具体表现为:复制或下载文件,发送电子邮件以响应事件,更新数据仓库,清除和挖掘数据以及管理 SQL Server 对象和数据" ,可以说SSIS已经跨入企业级ETL工具。可以通过多种方法使用该工具(包),可参考一篇: http://www.cnblogs.com/aspnetx/p/3377003.html

或者:使用SSIS创建同步数据库数据任务的方法

Looks like the new SQL Server 2017 supports more func to support incremental data export: https://docs.microsoft.com/zh-cn/sql/int...https://docs.microsoft.com/zh-cn/sql/integration-services/change-data-capture/change-data-capture-ssis?view=sql-s
Quote this message in a reply
08-01-2016, 10:19 PM
Post: #2
RE: SSIS(Sql Server Integration Services)
a way to capture data changed : https://msdn.microsoft.com/zh-cn/library...https://msdn.microsoft.com/zh-cn/library/bb895315(v=sql
Quote this message in a reply
08-02-2016, 10:16 AM
Post: #3
RE: SSIS(Sql Server Integration Services)
A paper to introduce how to open data changed capture: http://www.jb51.net/softjc/119040.html
Quote this message in a reply
07-11-2018, 01:54 PM (This post was last modified: 07-11-2018 01:54 PM by xwcwt.)
Post: #4
RE: SSIS(Sql Server Integration Services)
Looks like the new SQL Server 2017 supports more func to support incremental data export: https://docs.microsoft.com/zh-cn/sql/int...https://docs.microsoft.com/zh-cn/sql/integration-services/change-data-capture/change-data-capture-ssis?view=sql-s
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump: