Naming Conventions (SSIS 2019+)
Favorite Tasks
| Task | Prefix |
|---|---|
| Data Flow Task | DFT |
| Execute SQL Task | SQL |
Common Tasks
| Task | Prefix |
|---|---|
| Analysis Services Processing Task | ASP |
| Bulk Insert Task | BLK |
| Data Profiling Task | DPT |
| Execute Package Task | EPT |
| Execute Process Task | EPR |
| Expression Task | EXPR |
| File System Task | FSYS |
| FTP Task | FTP |
| Hadoop File System Task | HFSYS |
| Hadoop Hive Task | HIV |
| Hadoop Pig Task | HPIG |
| Script Task | SCR |
| Send Mail Task | MAIL |
| Web Service Task | WEB |
| XML Task | XML |
Azure Tasks
| Task | Prefix |
|---|---|
| Azure Blob Download Task | ABD |
| Azure Blob Upload Task | ABU |
| Azure Data Lake Analytics Task | ADLA |
| Azure Data Lake Store File System Task | ADLFSYS |
| Azure HDInsight Create Cluster Task | AHDICC |
| Azure HDInsight Delete Cluster Task | AHDIDC |
| Azure HDInsight Hive Task | AHDIHIV |
| Azure HDInsight Pig Task | AHDIPIG |
| Azure SQL DW Upload Task | ASQLDWU |
| Flexible File Task | FLXFIL |
Containers
| Container Type | Prefix |
|---|---|
| Sequence Container | SEQ |
| For Loop Container | FOR |
| Foreach Loop Container | FOREACH |
Other Tasks
| Task | Prefix |
|---|---|
| Analysis Services Execute DDL Task | ASE |
| Backup Database Task | SQLBKUP |
| CDC Control Task | CDC |
| Check Database Integrity Task | CDI |
| Data Mining Query Task | DMQ |
| Execute SQL Server Agent Job Task | SQLAGENT |
| Execute T-SQL Statement Task | TSQL |
| History Cleanup Task | HISTCLEAN |
| Maintenance Cleanup Task | MAINTCLEAN |
| Message Queue Task | MSGQUEUE |
| Notify Operator Task | NOT |
| Rebuild Index Task | REBIND |
| Reorganize Index Task | REORGIND |
| SHRINK Database Task | SHRDB |
| Transfer Database Task | XFERDB |
| Transfer Error Messages Task | XFERMSG |
| Transfer Jobs Task | XFERJOB |
| Transfer Logins Task | XFERLOGIN |
| Transfer Master Stored Procedures Task | XFERMSP |
| Transfer SQL Server Objects Task | XFERSQL |
| Update Statistics Task | UPDSTATS |
| WMI Data Reader Task | WMIDR |
| WMI Event Watcher Task | WMIEVENT |
Data Flow – Common
| Component | Prefix |
|---|---|
| Aggregate | AGG |
| Balanced Data Distributor | BDD |
| Conditional Split | CS |
| Data Conversion | CONV |
| Data Streaming Destination | STRDEST |
| Derived Column | DER |
| HDFS File Destination | HDFSDEST |
| HDFS File Source | BDFSSRC |
| Lookup | LKUP |
| Merge | MRG |
| Merge Join | MRGJN |
| Multicast | MULT |
| OData Source | ODATASRC |
| ODBC Destination | ODBCDEST |
| ODBC Source | ODBCSRC |
| OLE DB Command | OLEDBCMD |
| Row Count | ROWCNT |
| Script Component | SCRC |
| Slowly Changing Dimension | SCD |
| Sort | SORT |
| Union All | UNION |
Data Flow – Azure
| Component | Prefix |
|---|---|
| Azure Blob Destination | BLOBDEST |
| Azure Blob Source | BLOBSRC |
| Azure Data Lake Store Destination | DLAKEDEST |
| Azure Data Lake Store Source | DLAKESRC |
| Flexible File Destination | FLEXFILEDEST |
| Flexible File Source | FLEXFILESRC |
Data Flow – Other Transforms
| Component | Prefix |
|---|---|
| Audit | AUD |
| Cache Transform | CACHE |
| CDC Splitter | CDCSPL |
| Character Map | CHMAP |
| Copy Column | COPY |
| Data Mining Query | DMQRY |
| DQS Cleansing | DQS |
| Export Column | EXPCOL |
| Fuzzy Grouping | FUZGRP |
| Fuzzy Lookup | FUZLKUP |
| Import Column | IMPCOL |
| Percentage Sampling | PERCSMPL |
| Pivot | PIVOT |
| Row Sampling | ROWSMPL |
Data Flow – Other Sources
| Component | Prefix |
|---|---|
| ADO NET Source | ADONETSRC |
| CDC Source | CDCSRC |
| Excel Source | EXCELSRC |
| Flat File Source | FFSRC |
| OLE DB Source | OLEDBSRC |
| Raw File Source | RAWSRC |
| XML Source | XMLSRC |
Data Flow – Other Destinations
| Component | Prefix |
|---|---|
| ADO NET Destination | ADODEST |
| Data Mining Model Training | DMMTRAIN |
| Data Reader Destination | DRDEST |
| Dimension Processing | DIMPROC |
| Excel Destination | EXCELDEST |
| Flat File Destination | FFDEST |
| OLE DB Destination | OLEDBDEST |
| Partition Processing | PARTPROC |
| Raw File Destination | RAWDEST |
| Recordset Destination | RSDEST |
| SQL Server Compact Destination | SQLCOMPDEST |
| SQL Server Destination | SQLDEST |