ITPub博客

首页 > Linux操作系统 > Linux操作系统 > SSIS Package 命名规则

SSIS Package 命名规则

原创 Linux操作系统 作者:magicgao8888 时间:2009-03-11 10:46:03 0 删除 编辑

在做SSIS项目的时候大家都会遇到一个统一的问题,那就是命名规则,下面是我在做项目时候的命名规则,希望能够与大家分享,如果你有更好的建议,也欢迎您和我讨论。

1.Control Flow

Task Prefix Sample
For Loop Container FLC  
Foreach Loop Container 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 Logins TLT  
Transfer Master Stored Procedures TSP  
Transfer SQL Server Objects TSO  
Web Service WST  
WMI Data Reader WMID  
WMI Event Watcher WMIE  
XML XML  

2.Data Flow

Component Prefix Sample
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  
SQL Server Mobile Destination SSM_DST  

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14321372/viewspace-566758/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-03-10

  • 博文量
    35
  • 访问量
    73637