People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server MVP Jamie Thomson: Suggested Best Practises and naming conventions. The blog post served as a guidance point for many SSIS projects regarding naming conventions of the various tasks and components. I still use them every day.
However, the original list has gotten a bit out of date as new components have been added to SSIS over the past releases. Together with MVPs Joost van Rossum (blog | twitter) and André Kamman (blog | twitter) we’ve created an updated list. If that’s not enough, Joost and André have created a PowerShell script that will enable you to check those naming conventions. It will be posted soon on Github.
| Task name | Prefix | Type | New |
|---|---|---|---|
| For Loop Container | FLC | Container | |
| Foreach Loop Container | FELC | Container | |
| Sequence Container | SEQC | Container | |
| ActiveX Script | AXS | Task | |
| Analysis Services Execute DDL Task | ASE | Task | |
| Analysis Services Processing Task | ASP | Task | |
| Azure Blob Download Task | ADT | Task | * |
| Azure Blob Upload Task | AUT | Task | * |
| Azure HDInsight Create Cluster Task | ACCT | Task | * |
| Azure HDInsight Delete Cluster Task | ACDT | Task | * |
| Azure HDInsight Hive Task | AHT | Task | * |
| Azure HDInsight Pig Task | APT | Task | * |
| Back Up Database Task | BACKUP | Task | * |
| Bulk Insert Task | BLK | Task | |
| CDC Control Task | CDC | Task | * |
| Check Database Integrity Task | CHECKDB | Task | * |
| Data Flow Task | DFT | Task | |
| Data Mining Query Task | DMQ | Task | |
| Data Profiling Task | DPT | Task | * |
| Execute Package Task | EPT | Task | |
| Execute Process Task | EPR | Task | |
| Execute SQL Server Agent Job Task | AGENT | Task | * |
| Execute SQL Task | SQL | Task | |
| Execute T-SQL Statement Task | TSQL | Task | * |
| Expression Task | EXPR | Task | |
| File System Task | FSYS | Task | |
| FTP Task | FTP | Task | |
| Hadoop File System Task | HFSYS | Task | * |
| Hadoop Hive Task | HIVE | Task | * |
| Hadoop Pig Task | PIG | Task | * |
| History Cleanup Task | HISTCT | Task | * |
| Maintenance Cleanup Task | MAINCT | Task | * |
| Message Queue Task | MSMQ | Task | |
| Notify Operator Task | NOT | Task | * |
| Rebuild Index Task | REBIT | Task | * |
| Reorganize Index Task | REOIT | Task | * |
| Script Task | SCR | Task | |
| Send Mail Task | SMT | Task | |
| Shrink Database Task | SHRINKDB | Task | * |
| Transfer Database Task | TDB | Task | |
| Transfer Error Messages Task | TEM | Task | |
| Transfer Jobs Task | TJT | Task | |
| Transfer Logins Task | TLT | Task | |
| Transfer Master Stored Procedures Task | TSP | Task | |
| Transfer SQL Server Objects Task | TSO | Task | |
| Update Statistics Task | STAT | Task | * |
| Web Service Task | WST | Task | |
| WMI Data Reader Task | WMID | Task | |
| WMI Event Watcher Task | WMIE | Task | |
| XML Task | XML | Task | |
| Transformation name | Prefix | Type | New |
| ADO NET Source | ADO_SRC | Source | * |
| Azure Blob Source | AB_SRC | Source | * |
| CDC Source | CDC_SRC | Source | * |
| DataReader Source | DR_SRC | Source | |
| Excel Source | EX_SRC | Source | |
| Flat File Source | FF_SRC | Source | |
| HDFS File Source | HDFS_SRC | Source | * |
| OData Source | ODATA_SRC | Source | * |
| ODBC Source | ODBC_SRC | Source | * |
| OLE DB Source | OLE_SRC | Source | |
| Raw File Source | RF_SRC | Source | |
| SharePoint List Source | SPL_SRC | Source | |
| XML Source | XML_SRC | Source | |
| Aggregate | AGG | Transformation | |
| Audit | AUD | Transformation | |
| Balanced Data Distributor | BDD | Transformation | * |
| Cache Transform | CCH | Transformation | * |
| CDC Splitter | CDCS | Transformation | * |
| Character Map | CHM | Transformation | |
| Conditional Split | CSPL | Transformation | |
| Copy Column | CPYC | Transformation | |
| Data Conversion | DCNV | Transformation | |
| Data Mining Query | DMQ | Transformation | |
| Derived Column | DER | Transformation | |
| DQS Cleansing | DQSC | Transformation | * |
| Export Column | EXPC | Transformation | |
| Fuzzy Grouping | FZG | Transformation | |
| Fuzzy Lookup | FZL | Transformation | |
| Import Column | IMPC | Transformation | |
| Lookup | LKP | Transformation | |
| Merge | MRG | Transformation | |
| Merge Join | MRGJ | Transformation | |
| Multicast | MLT | Transformation | |
| OLE DB Command | CMD | Transformation | |
| Percentage Sampling | PSMP | Transformation | |
| Pivot | PVT | Transformation | |
| Row Count | CNT | Transformation | |
| Row Sampling | RSMP | Transformation | |
| Script Component | SCR | Transformation | |
| Slowly Changing Dimension | SCD | Transformation | |
| Sort | SRT | Transformation | |
| Term Extraction | TEX | Transformation | |
| Term Lookup | TEL | Transformation | |
| Union All | ALL | Transformation | |
| Unpivot | UPVT | Transformation | |
| ADO NET Destination | ADO_DST | Destination | * |
| Azure Blob Destination | AB_DST | Destination | * |
| Data Mining Model Training | DMMT_DST | Destination | |
| Data Streaming Destination | DS_DST | Destination | * |
| DataReaderDest | DR_DST | Destination | |
| Dimension Processing | DP_DST | Destination | |
| Excel Destination | EX_DST | Destination | |
| Flat File Destination | FF_DST | Destination | |
| HDFS File Destination | HDFS_DST | Destination | * |
| ODBC Destination | ODBC_DST | Destination | * |
| OLE DB Destination | OLE_DST | Destination | |
| Partition Processing | PP_DST | Destination | |
| Raw File Destination | RF_DST | Destination | |
| Recordset Destination | RS_DST | Destination | |
| SharePoint List Destination | SPL_DST | Destination | |
| SQL Server Compact Destination | SSC_DST | Destination | * |
| SQL Server Destination | SS_DST | Destination |
You can find all the session materials for the presentation "Indexing for Dummies" that was…
The slidedeck and the SQL scripts for the session Indexing for Dummies can be found…
You can find the slides of my session on the €100 DWH in Azure on…
I've used Logic Apps a couple of times over the past years for simple workflows,…
I'm giving two online sessions soon on virtual events that are free to attend. The…
I wanted to try out the new JSON index which is for the moment only…
View Comments
Thanks for sharing. Quite Useful for beginners like me :)
when is it going to appear on github? i'd lov to test this.
Hi Felix,
I'm not involved in the PowerShell development.
You can ask Joost though.
http://microsoft-ssis.blogspot.be/
Hi Koen,
Thank you for updating the naming conventions of the various tasks and components of SSIS.
I hope that you don't mind me stating that SSIS can sometimes get too complicated to be used by beginners.
If you are interested, I can link you to a demonstration of a new simple ETL tool I've developed.
Thanks,
Bracha Goldstein
Hi Koen,
Just updating my mail...
(I made a mistake in the previous post, sorry).
Bracha Goldstein