SSIS naming conventions in a nice copy paste format

I’m a huge advocate of naming conventions. SSIS is no exception. At time of writing there’s an issue linking to the original blog post. It was Jamie Thompsons way back in 2006, here’s the latest reference to it.

I tend to keep these inside a template package so I don’t have to try to remember them all. Problem is if I’m on a client site, chances are I might not be able use my template and so I have to pull them from the web. Most sites list these naming conventions in tables and it doesn’t quite work for SSIS’ text blocks. It’s just not tidy and it is something that eats away at me until I need to do something about it. So I got to work on writing this. A plain text version of all the containers, tasks, sources etc in a nice format that you can copy paste straight into SSIS. Each block goes in its own text box and can then be lined up alongside each other.

There are probably better to things to worry about in life, but this is one less to worry about #winner

Annotation #1

-------------------------------------------------------------
Container
-------------------------------------------------------------
For Loop Container 
Foreach Loop Container 
Sequence Container
-------------------------------------------------------------
Task
-------------------------------------------------------------
ActiveX Script 
Analysis Services Execute DDL Task 
Analysis Services Processing Task 
Azure Blob Download Task 
Azure Blob Upload Task 
Azure HDInsight Create Cluster Task 
Azure HDInsight Delete Cluster Task 
Azure HDInsight Hive Task 
Azure HDInsight Pig Task 
Back Up Database Task 
Bulk Insert Task 
CDC Control Task 
Check Database Integrity Task 
Data Flow Task 
Data Mining Query Task 
Data Profiling Task 
Execute Package Task 
Execute Process Task 
Execute SQL Server Agent Job Task 
Execute SQL Task 
Execute T-SQL Statement Task 
Expression Task 
File System Task 
FTP Task 
Hadoop File System Task 
Hadoop Hive Task 
Hadoop Pig Task 
History Cleanup Task 
Maintenance Cleanup Task 
Message Queue Task 
Notify Operator Task 
Rebuild Index Task 
Reorganize Index Task 
Script Task 
Send Mail Task 
Shrink Database Task 
Transfer Database Task 
Transfer Error Messages Task 
Transfer Jobs Task 
Transfer Logins Task 
Transfer Master Stored Procedures Task 
Transfer SQL Server Objects Task 
Update Statistics Task 
Web Service Task 
WMI Data Reader Task 
WMI Event Watcher Task 
XML Task
-------------------------------------------------------------

Annotation #2 (start with 3 blank lines so it will line up with #1)


FLC
FELC
SEQC


AXS
ASE
ASP
ADT
AUT
ACCT
ACDT
AHT 
APT
BACKUP
BLK
CDC
CHECKDB
DFT
DMQ
DPT
EPT
EPR
AGENT
SQL
TSQL
EXPR
FSYS
FTP
HFSYS
HIVE
PIG
HISTCT
MAINCT
MSMQ
NOT
REBIT
REOIT
SCR
SMT
SHRINKDB
TDB
TEM
TJT
TLT
TSP
TSO
STAT
WST
WMID
WMIE
XML

Annotation #3

-------------------------------------------------------------
Source
-------------------------------------------------------------
ADO NET Source 
Azure Blob Source 
CDC Source 
DataReader Source 
Excel Source 
Flat File Source 
HDFS File Source 
OData Source 
ODBC Source 
OLE DB Source 
Raw File Source 
SharePoint List Source 
XML Source 
-------------------------------------------------------------
Destination
-------------------------------------------------------------
ADO NET Destination 
Azure Blob Destination 
Data Mining Model Training 
Data Streaming Destination 
DataReaderDest 
Dimension Processing 
Excel Destination 
Flat File Destination 
HDFS File Destination 
ODBC Destination 
OLE DB Destination 
Partition Processing 
Raw File Destination 
Recordset Destination 
SharePoint List Destination 
SQL Server Compact Destination 
SQL Server Destination 
-------------------------------------------------------------

Annotation #4 (start with 3 blank lines so it will line up with #3)


ADO_SRC
AB_SRC
CDC_SRC
DR_SRC
EX_SRC
FF_SRC
HDFS_SRC
ODATA_SRC
ODBC_SRC
OLE_SRC
RF_SRC
SPL_SRC
XML_SRC


ADO_DST
AB_DST
DMMT_DST
DS_DST
DR_DST
DP_DST
EX_DST
FF_DST
HDFS_DST
ODBC_DST
OLE_DST
PP_DST
RF_DST
RS_DST
SPL_DST
SSC_DST
SS_DST

Annotation #5

-------------------------------------------------------------
Transformation
-------------------------------------------------------------
Aggregate 
Audit 
Balanced Data Distributor 
Cache Transform 
CDC Splitter 
Character Map 
Conditional Split 
Copy Column 
Data Conversion 
Data Mining Query 
Derived Column 
DQS Cleansing 
Export Column 
Fuzzy Grouping 
Fuzzy Lookup 
Import Column 
Lookup 
Merge 
Merge Join 
Multicast 
OLE DB Command 
Percentage Sampling 
Pivot 
Row Count 
Row Sampling 
Script Component 
Slowly Changing Dimension 
Sort 
Term Extraction 
Term Lookup 
Union All 
Unpivot 
-------------------------------------------------------------

Annotation #6 (start with 3 blank lines so it will line up with #5)


AGG
AUD
BDD
CCH
CDCS
CHM
CSPL
CPYC
DCNV
DMQ
DER
DQSC
EXPC
FZG
FZL
IMPC
LKP
MRG
MRGJ
MLT
CMD
PSMP
PVT
CNT
RSMP
SCR
SCD
SRT
TEX
TEL
ALL
UPVT
Share this post...

Leave a Reply

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