没有合适的资源?快使用搜索试试~ 我知道了~
Integration Services in SQL Server 2005
1星 需积分: 9 23 下载量 85 浏览量
2009-02-25
09:42:33
上传
评论
收藏 1.91MB DOC 举报
温馨提示
试读
64页
Integration Services in SQL Server 2005
资源推荐
资源详情
资源评论
Integration Services in SQL Server 2005(SSIS)
Tata Consultancy Services Ltd. 1
Table of Contents
1.1 Geng Started:.....................................................................................................................................5
1.2 Microso SQL Server 2005 Integra!on Services Overview:...................................................................6
1.3 Wizards for SSIS:....................................................................................................................................8
1.4 Geng Familiar with Business Intelligence Development Studio:.......................................................11
1.5 Common and Custom Proper!es in SSIS:.............................................................................................23
1.5.1 COMMON PROPERTIES:................................................................................................................23
Component Proper!es:.........................................................................................................................23
Input Proper!es:....................................................................................................................................24
Input Column Proper!es........................................................................................................................25
Output Proper!es:.................................................................................................................................26
Output Column Proper!es:....................................................................................................................26
External Metadata Column Proper!es:.................................................................................................28
Data Type Proper!es:............................................................................................................................28
1.5.2 Custom Proper!es:.......................................................................................................................28
1.5.2.1 Source Custom Proper!es:....................................................................................................29
1.5.2.2 Des!na!on Custom Proper!es:.............................................................................................36
1.5.3 Path Proper!es:............................................................................................................................47
1.6 Integra!on Services Transforma!on:...................................................................................................48
1.6.1 Business Intelligence Transforma!ons:.........................................................................................48
1.6.1.1 Fuzzy Grouping Transforma!on.............................................................................................48
1.6.1.2 Fuzzy Lookup Transforma!on:...............................................................................................55
Maintenance of the Match Index Table:............................................................................................57
1.6.1.3 Term Extrac!on Transforma!on:...........................................................................................62
Tokenizing Text:.................................................................................................................................63
Tagging Words:..................................................................................................................................64
Stemming Words:..............................................................................................................................65
Normalizing Words:...........................................................................................................................65
Using Case-Sensi!ve Normaliza!on:..................................................................................................65
1.6.1.4 Term Lookup Transforma!on:...............................................................................................70
Tata Consultancy Services Ltd. 2
1.6.1.5 Data Mining Query Transforma!on:......................................................................................75
1.6.2 Row Transforma!ons:...................................................................................................................77
1.6.2.1 Character Map Transforma!on:.............................................................................................77
1.6.2.2 Copy Column Transforma!on:...............................................................................................79
1.6.2.3 Data Conversion Transforma!on:..........................................................................................80
1.6.2.4 Derived Column Transforma!on:...........................................................................................83
1.6.2.5 Script Component:.................................................................................................................85
1.6.2.6 OLE DB Command Transforma!on:.......................................................................................90
1.6.3 Rowset Transforma!ons:..............................................................................................................93
1.6.3.1 Aggregate Transforma!on:....................................................................................................93
1.6.3.2 Sort Transforma!on:............................................................................................................102
1.6.3.3 Percentage Sampling Transforma!on:.................................................................................105
1.6.3.4 Row Sampling Transforma!on:............................................................................................107
1.6.3.5 Pivot Transforma!on:..........................................................................................................110
1.6.3.6 Unpivot Transforma!on:......................................................................................................113
1.6.4 Split and Join Transforma!ons:...................................................................................................116
1.6.4.1 Condi!onal Split Transforma!on:........................................................................................116
1.6.4.2 Mul!cast Transforma!on:...................................................................................................120
1.6.4.3 Union All Transforma!on:....................................................................................................121
1.6.4.4 Merge Transforma!on:........................................................................................................123
1.6.4.5 Merge Join Transforma!on:.................................................................................................125
1.6.4.6 Lookup Transforma!on:.......................................................................................................129
1.6.5 Other Transforma!ons:..............................................................................................................134
1.6.5.1 Export Column Transforma!on:...........................................................................................135
1.6.5.2 Import Column Transforma!on:..........................................................................................138
1.6.5.3 Audit Transforma!on:..........................................................................................................139
1.6.5.4 Row Count Transforma!on:.................................................................................................140
1.6.5.5 Slowly Changing Dimension Transforma!on:......................................................................141
Tata Consultancy Services Ltd. 3
Tata Consultancy Services Ltd. 4
1.1 Getting Started:
! "
# $ % &
'!
Business Intelligence (BI) Development Studio%
( SQL Server Management Studio!
&)*
+,!
) & - ,% & ) (
- % -,
&!).%
.%%,%+!/
-%.,(0(,
((&!(++
+&(0,!1
(%(0(+!
) 0 2 3)
,%2(,!).
.%.,$!)
$(!*
.%(&(,$!
%,)%()*
%*(%3!-
,%&!4%
,-,!
Tata Consultancy Services Ltd. 5
剩余63页未读,继续阅读
资源评论
- houhouziff2013-02-28看了 一样配置不了SQL2005计划维护表
MyHoliday_2008
- 粉丝: 0
- 资源: 38
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功