SSIS Prefix Naming Convention

For Task

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
Bulk Insert	BI
Data Flow	DF
Data Mining Query	DMQ
Execute DTS 2000 Package	EDP
Execute Package	EP
Execute Process	EPR
Execute SQL	SQL
File System	FS
FTP	FTP
Message Queue	MQ
Script	SCR
Send Mail	SM
Transfer Database	TDB
Transfer Error Messages	TEM
Transfer Jobs	TJ
Transfer Logins	TL
Transfer Master Stored Procedures	TSP
Transfer SQL Server Objects	TSO
Web Service	WS
WMI Data Reader	WMID
WMI Event Watcher	WMIE
XML	XML

For Component

Component	Prefix
DataReader Source	DR_SRC
Excel Source	EX_SRC
Flat File Source	FF_SRC
OLE DB Source	OLE_SRC
Raw File Source	RF_SRC
XML Source	XML_SRC
Aggregate	AGG
Audit	AUD
Character Map	CHM
Conditional Split	CSP
Copy Column	CPC
Data Conversion	DC
Data Mining Query	DMQ
Derived Column	DER
Export Column	EXP
Fuzzy Grouping	FZG
Fuzzy Lookup	FZL
Import Column	IMPT
Lookup	LKP
Merge	MRG
Merge Join	MRJ
Multicast	MLT
OLE DB Command	CMD
Percentage Sampling	PS
Pivot	PVT
Row Count	RC
Row Sampling	RS
Script Component	SC
Slowly Changing Dimension	SCD
Sort	SRT
Term Extraction	TEX
Term Lookup	TLK
Union All	UAL
Unpivot	UPVT
Data Mining Model Training	DMT_DST
DataReader Destination	DR_DST
Dimension Processing	DP_DST
Excel Destination	EX_DST
Flat File Destination	FF_DST
OLE DB Destination	OLE_DST
Partition Processing	PP_DST
Raw File Destination	RF_DST
Recordset Destination	RS_DST
SQL Server Destination	SS_DST
SQL Server Mobile Destination	SSM_DST

Advertisement