ed2kers 电驴资源下载站

《精通 SQL Server 2012 集成服务》(Pro SQL Server 2012 Integration Services)英文版[PDF]

《精通 SQL Server 2012 集成服务》(Pro SQL Server 2012 Integration Services)英文版[PDF]
类别:
图书 - 计算机与网络
状态:
普通资源
发布:
2012-09-23 19:53:00
更新:
2012-10-28 18:54:00

电驴资源

电驴资源简介

资源介绍
语言: 英文
地区: 美国
图书fenlei: 软件
中文名: 精通 SQL Server 2012 集成服务
发行时间: 2012年
原名: Pro SQL Server 2012 Integration Services
资源格式: PDF
版本: 英文版
简介:
用Foxit Reader最新版打开pdf
内容介绍:
集成服务(Integration Services)是用于生成高性能数据集成和工作流解决方案(包括针对数据仓库的提取、转换和加载 (ETL) 操作)的平台。集成服务包括生成并调试包的图形工具和向导;执行如数据导入、导出, FTP 操作,SQL 语句执行和电子邮件消息传递等工作流功能的任务等。
Pro SQL Server 2012 Integration Services teaches how to take advantage of the powerful extract, transform, and load (ETL) platform included with Microsoft SQL Server 2012. You’ll learn to build scalable, robust, performance-driven enterprise ETL solutions that save time and make money for your company. You'll learn to avoid common ETL development pitfalls and how to extend the power of your ETL solutions to include virtually any possible transformation on data from any conceivable source. SQL Server Integration Services (SSIS) facilitates an unprecedented ability to load data from anywhere, perform any type of manipulation on it, and store it to any source.
Whether you are populating databases, retrieving data from the Web, or performing complex calculations on large data sets, SSIS gives you the tools to get the job done. And this book gives you the knowledge to take advantage of everything SSIS offers.
内容截图:
目录: About the Authors............................................................................................... xvii
About the Technical Reviewer ........................................................................... xviii
 Chapter 1: Introducing Integration Services...........................................................1
 Chapter 2: BIDS and SSMS....................................................................................11
 Chapter 3: Hello World—Your First SSIS 2012 Package......................................43
 Chapter 4: Connection Managers..........................................................................83
 Chapter 5: Control Flow Basics...........................................................................107
 Chapter 6: Advanced Control Flow Tasks ...........................................................163
 Chapter 7: Source and Destination Adapters......................................................203
 Chapter 8: Data Flow Transformations ...............................................................245
 Chapter 9: Variables, Parameters, and Expressions..........................................325
 Chapter 10: Scripting..........................................................................................361
 Chapter 11: Events and Error Handling...............................................................405
 Chapter 12: Data Profiling and Scrubbing ..........................................................427
 Chapter 13: Logging and Auditing ......................................................................465
 Chapter 14: Heterogeneous Sources and Destinations.......................................487
 Chapter 15: Data Flow Tuning and Optimization ................................................511
 Chapter 16: Parent-Child Design Pattern............................................................525
 Chapter 17: Dimensional Data ETL......................................................................543
 Chapter 18: Building Robust Solutions ...............................................................561
 Chapter 19: Deployment Model...........................................................................579
 Index ...................................................................................................................605