在做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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14321372/viewspace-566758/