IT Nota

  • Home
  • How To
  • .NET
  • WordPress
  • Contact
You are here: Home / Tips and Tricks / SSIS Best Practice with Naming Conventions

SSIS Best Practice with Naming Conventions

In 2006, Jamie Thomson originally came up with naming conventions for SSIS tasks and data flow components which makes packages and logs more readable and easier to find.

Koen Verbeeck and André Kamman extended the existing list with almost 40 tasks/components since then.

This list should be used just as a reference if you want to use standard naming convention in SSIS.

The point is whether or not you want to follow this naming standard, it’s always better to use a standard for your package maintainability and readibility.

Task

The acronyms below can be used at the beginning of the names of tasks to identify what type of task it is.

Task Prefix
For Loop Container FLC
Foreach Loop Container FELC
Sequence Container SEQC
ActiveX Script AXS
Analysis Services Execute DDL ASE
Analysis Services Processing ASP
Azure Blob Download ADT
Azure Blob Upload AUT
Azure HDInsight Create Cluster ACCT
Azure HDInsight Delete Cluster ACDT
Azure HDInsight Hive AHT
Azure HDInsight Pig APT
Back Up Database BACKUP
Bulk Insert BLK
CDC Control CDC
Check Database Integrity CHECKDB
Data Flow DFT
Data Mining Query DMQ
Data Profiling DPT
Execute DTS 2000 Package EDPT
Execute Package EPT
Execute Process EPR
Execute SQL Server Agent Job AGENT
Execute SQL SQL
Execute T-SQL Statement TSQL
File System FSYS
FTP FTP
Hadoop File System HFSYS
Hadoop Hive HIVE
Hadoop Pig PIG
History Cleanup HISTCT
Maintenance Cleanup MAINCT
Message Queue MSMQ
Notify Operator NOT
Rebuild Index REBIT
Reorganize Index REOIT
Script SCR
Send Mail SMT
Shrink Database SHRINKDB
Transfer Database TDB
Transfer Error Messages TEM
Transfer Jobs TJT
Transfer Logins TLT
Transfer Master Stored Procedures TSP
Transfer SQL Server Objects TSO
Update Statistics STAT
Web Service WST
WMI Data Reader WMID
WMI Event Watcher WMIE
XML XML
Expression EXPR

Components

These acronyms should be used at the beginning of the names of components to identify what type of component it is.

Component Prefix
ADO NET Source ADO_SRC
Azure Blob Source AB_SRC
CDC Source CDC_SRC
DataReader Source DR_SRC
Excel Source EX_SRC
Flat File Source FF_SRC
HDFS File Source HDFS_SRC
OData Source ODATA_SRC
ODBC Source ODBC_SRC
OLE DB Source OLE_SRC
Raw File Source RF_SRC
XML Source XML_SRC
Aggregate AGG
Audit AUD
Balanced Data Distributor BDD
Cache Transform CCH
CDC Splitter CDCS
Character Map CHM
Conditional Split CSPL
Copy Column CPYC
Data Conversion DCNV
Data Mining Query DMQ
Derived Column DER
DQS Cleansing DQSC
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
ADO NET Destination ADO_DST
Azure Blob Destination AB_DST
Data Mining Model Training DMMT_DST
Data Streaming Destination DS_DST
DataReader Destination DR_DST
Dimension Processing DP_DST
Excel Destination EX_DST
Flat File Destination FF_DST
HDFS File Destination HDFS_DST
ODBC Destination ODBC_DST
OLE DB Destination OLE_DST
Partition Processing PP_DST
Raw File Destination RF_DST
Recordset Destination RS_DST
SharePoint List Destination SPL_DST
SQL Server Compact Destination SSC_DST
SQL Server Destination SS_DST
SQL Server Mobile Destination SSM_DST

Further Reading

SSIS Naming Conventions 2.0
How to Add Custom Logging to SSIS Package

January 9, 2023 Filed Under: Tips and Tricks Tagged With: ETL, Microsoft, SSIS

Buy me a coffee?

Buy me a coffee If you find any of the articles or demos helpful, please consider supporting my work here, you'll have my big thanks!

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Buy me a coffee Support this site
Buy Me a Coffee?

Categories

  • .NET
  • Coding
  • Cybersecurity
  • Database
  • How To
  • Internet
  • Multimedia
  • Photography
  • Programming
  • Resources
  • Review
  • Tips and Tricks
  • Use Case
  • WordPress
  • Writing

Recent Posts

  • How to Delay Shutdown or Restart on a Mac
  • How to Activate Built-in Web Server
  • SSIS Best Practice with Naming Conventions
  • How to Delay Shutdown or Restart on a Windows Server
  • How to Type Emoji Using Keyboard Shortcuts in Windows and macOS

Recent Posts

  • How to Delay Shutdown or Restart on a Mac
  • How to Activate Built-in Web Server
  • SSIS Best Practice with Naming Conventions
  • How to Delay Shutdown or Restart on a Windows Server
  • How to Type Emoji Using Keyboard Shortcuts in Windows and macOS

Tags

.NET ASP.NET Cdonts Dll Classic ASP Code Editor ETL FSharp Genesis Framework Git Google HP Asset Manager HTML5 Hugo IIS Information Security Internet Internet Information Services iOS JAMStack JavaScript Linux macOS Microsoft Microsoft SQL Server MVC PHP PowerShell Python Simple Mail Transfer Protocol Smtp Server SQL SQL Server SSIS SSMS SSRS Sublime Text Visual Studio Visual Studio Code VPN Web Server Windows Windows 8 Windows 10 Windows 2012 Windows Server

Copyright © 2011-2023 IT Nota. All rights reserved. Terms of Use | Privacy Policy | Disclosure