af Henrik Jensen
27. juli 2018 13:19
Det er en god ide (Best Practice) at navngive de objekter man benytter i SSIS med bestemte præfiks, så det det er lettere at identificere disse visuel og i XML-koden.
Der findes en række forskellige forslag til navnekonventioner. Microsoft har frigivet en konvention. Læs mere her (Engelsk): SSIS Naming Convention – Updated for SSIS 2016...
Man kan downloade navnekonventionerne i et Excel-dokument her: SSIS Component Naming Convention Prefixes...
Jeg benytter en lidt anden navnekonvention end den Microsoft anbefaler. De overordnede komponenter giver jeg følgende præfix:
| Komponent |
Præfix |
|
Destination/Sources |
Præfix |
| Aggregate |
AGG |
|
ADO NET Destination |
ADONET_DST |
| Balanced Data Distributor |
BDD |
|
ADO NET Source |
ADONET_SRC |
| Cache Transform |
CHT |
|
Dynamics AX Destination |
DYNAX_DST |
| Conditional Split |
CSPL |
|
Dynamics AX Source |
DYNAX_SRC |
| Data Conversion |
DCNV |
|
Dynamics CRM Destination |
DYNCRM_DST |
| Derived Column |
DER |
|
Dynamics CRM Source |
DYNCRM_SRC |
| Lookup |
LKP |
|
Dynamics NAV Destination |
DYNNAV_DST |
| Merge |
MRG |
|
Dynamics NAV Source |
DYNNAV_SRC |
| Merge Join |
MRGJ |
|
Excel Destination |
EX_DST |
| Multicast |
MLT |
|
Excel Source |
EX_SRC |
| Pivot |
PVT |
|
Flat File Destination |
FF_DST |
| Row Count |
CNT |
|
Flat File Source |
FF_SRC |
| Row Sampling |
RSMP |
|
OLE DB Command |
CMD |
| Script Component |
SCR |
|
OLE DB Destination |
OLE_DST |
| Slowly Changing Dimension |
SCD |
|
OLE DB Source |
OLE_SRC |
| Sort |
SRT |
|
Raw File Destination |
RF_DST |
| Term Extraction |
TEX |
|
Raw File Source |
RF_SRC |
| Term Lookup |
TEL |
|
Recordset Destination |
RS_DST |
| Union All |
ALL |
|
SQL Server Destination |
SS_DST |
| Unpivot |
UPVT |
|
SQL Server Mobile Destination |
SSM_DST |
| |
|
|
XML Source |
XML_SRC |