SSIS Tips.Naming Conventions (SSIS 2019) - Control Flow
Favorite Tasks
Common Tasks
Azure Tasks
Containers
Other Tasks
Data Flow - Common
Data Flow - Azure
Data Flow - Other Transforms
Data Flow - Other Sources
Data Flow - Other Destinations
Favorites | |
Task | Prefix |
Data Flow Task | DFT |
Execute SQL Task | SQL |
Common | |
Task | Prefix |
Anaysis 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 | |
Web Service Task | WEB |
XML Task | XML |
Azure | |
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 | |
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 |
SSIS Tips.Naming Conventions (SSIS 2019) - Data Flow Task
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 |
SQ Server Destination | SQLDEST |