SSIS 包组件的命名规则

SSIS 包组件的命名规则

 
为了创建一个良好的SSIS项目，需要一套命名规则去命名每个组件，使其意思清晰明了。
下面给出各个组件的推荐前缀如下：
SSIS任务命名模板
Task  

 Prefix  

 
For Loop Container
 FLC
 
Foreach Loop Conatiner
 FELC
 
Sequence Container
 SEQC
 
ActiveX Script
 AXS
 
Analysis Services Execute DDL
 ASE
 
Analysis Services Processing
 ASP
 
Bulk Insert
 BLK
 
Data Flow
 DFT
 
Data Mining Query
 DMQ
 
Execute DTS 2000 Package
 EDPT
 
Execute Package
 EPT
 
Execute Process
 EPR
 
Execute SQL
 SQL
 
File System
 FSYS
 
FTP
 FTP
 
Message Queue
 MSMQ
 
Script
 SCR
 
Send Mail
 SMT
 
Transfer Database
 TDB
 
Transfer Error Messages
 TEM
 
Transfer Jobs
 TJT
 
Transfer Master Stored Procedures
 TSP
 
Transfer SQL Server Objects
 TSO
 
Web Service
 WST
 
WMI Data Reader
 WMID
 
WMI Event Watcher
 WMIE
 
XML
 XML
 

SSIS组件命名模板
Component  

 Prefix  

 
DataReader Source
 DR_SRC
 
Excel Source
 EX_SRC
 
Flat File Source
 FF_SRC
 
OLE DB Source
 OLE_SRC
 
Raw File Source
 RF_SRC
 
XML Source
 XML_SRC
 
Aggregate
 AGG
 
Audit
 AUD
 
Character Map
 CHM
 
Conditional Split
 CSPL
 
Copy Column
 CPYC
 
Data Conversion
 DCNV
 
Data Mining Query
 DMQ
 
Derived Column
 DER
 
Export Column
 EXPC
 
Fuzzy Grouping
 FZG
 
Fuzzy Lookup
 FZL
 
Import Column
 IMPC
 
Lookup
 LKP
 
Merge
 MRG
 
Merge Join
 MRGJ
 
Multicast
 MLT
 
OLE DB Command
 CMD
 
Percentage Sampling
 PSMP
 
Pivot
 PVT
 
Row Count
 CNT
 
Row Sampling
 RSMP
 
Script Component
 SCR
 
Slowly Changing Dimension
 SCD
 
Sort
 SRT
 
Term Extraction
 TEX
 
Term Lookup
 TEL
 
Union All
 ALL
 
Unpivot
 UPVT
 
Data Mining Model Training
 DMMT_DST
 
DataReader Destination
 DR_DST
 
Dimension Processing
 DP_DST
 
Excel Destination
 EX_DST
 
Flat File Destination
 FF_DST
 
OLE DB Destination
 OLE_DST
 
Partition Processing
 PP_DST
 
Raw File Destination
 RF_DST
 
Recordset Destination
 RS_DST
 
SQL Server Destination
 SS_DST 
  

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/guoqiang1983/archive/2008/03/27/2223713.aspx