{"id":533,"date":"2018-06-24T16:40:04","date_gmt":"2018-06-24T14:40:04","guid":{"rendered":"https:\/\/staging.sql.marcus-belz.de\/?p=533"},"modified":"2026-05-07T01:06:39","modified_gmt":"2026-05-06T23:06:39","slug":"namenskonvention-fur-ssis-tasks-2","status":"publish","type":"post","link":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en","title":{"rendered":"Naming convention for SSIS Tasks"},"content":{"rendered":"<h2>Overview<\/h2>\n<p>The definition of programming guidelines and naming conventions only makes sense if the advantage outweighs the effort. One important prerequisite for this is the identification of the benefits. Readability and maintainability of code are generally in the focus of developers when talking about naming conventions. In case of <strong>SQL Server Integration Services<\/strong> (SSIS), however, another aspect must be considered: the logging of the execution of a package in the tab <strong>Execution Results<\/strong> or <strong>Progress<\/strong> in the development environment of Visual Studio . The execution result will be logged in a tree view. For complex packages with sub packages, For Each Loop Containers, Sequence Containers, etc., the tree structure quickly becomes long and deep. It is not possible to get an idea of the correct execution plan of tasks. And it seams to be impossible identifying quickly a task that has fired an exception. Who was not yet struggling with this supposedly simple task?!<\/p>\n<p>Let\u2019s have a look behind the scene. Visual Studio orders all tasks in the <strong>Execution Result<\/strong> tab by the task name and not the execution order of the tasks. The following screenshot shows the execution of a rather simple package in Visual Studio 2017:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-539 size-large\" src=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001-1024x324.png\" alt=\"\" width=\"1024\" height=\"324\" srcset=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001-1024x324.png 1024w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001-300x95.png 300w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001-768x243.png 768w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001.png 1133w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><strong>Annotations:<\/strong><\/p>\n<ul>\n<li>There are two Sequence Containers. The names of the containers are identical except the suffix. The container with the suffix <strong>2<\/strong> is executed prior to the container with the suffix <strong>1<\/strong>.<\/li>\n<li>Both Sequence Containers contain identical Control Flow Tasks. In each container the Control Flow Task with the prefix <strong>2<\/strong> is executed prior to the Control Flow Task with the prefix <strong>1<\/strong>.<\/li>\n<li>In between both Sequence Containers you find three Script Tasks. The task names are prefixed with the letters <strong>A<\/strong>, <strong>B<\/strong> and <strong>C<\/strong> in opposition to the execution order which is <strong>C<\/strong>, <strong>B<\/strong> and <strong>A<\/strong>.<\/li>\n<\/ul>\n<p>Both Control Flow Tasks with type of Data Flow Task are identical. The alphabetically ordered task names do not reflect the actual execution order which is <strong>OLE-DB Source <\/strong>prior to <strong>Count<\/strong>.<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012003.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-540 size-full\" src=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012003.png\" alt=\"\" width=\"179\" height=\"171\" \/><\/a><\/p>\n<p>Have a look at the <strong>Execution Results<\/strong> tab. The tasks are not ordered by the order of their execution but by their names:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012010.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-546 size-full\" src=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012010.png\" alt=\"\" width=\"444\" height=\"807\" srcset=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012010.png 444w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012010-165x300.png 165w\" sizes=\"auto, (max-width: 444px) 100vw, 444px\" \/><\/a><\/p>\n<p>Any execution result of complex transformations in SSIS must appear to be not legible. Frankly, I would like to get to know Microsoft\u2019s thoughts on that.<\/p>\n<p>The above shown screenshots are taken from Visual Studio. But is the situation different when deploying and executing an SSIS Package in SQL Servers\u2019 Integration Services Catalogs? Reports on the package executions within the Integration Services Catalogs can be opened by<\/p>\n<p style=\"padding-left: 40px;\"><em>right click on project\/Package &gt;<\/em> <strong>Reports| Standard Reports | All Executions<\/strong><\/p>\n<p>In fact, the overview site of any execution orders the log entries by the task names, too.<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012009.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-545 size-full\" src=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012009.png\" alt=\"\" width=\"568\" height=\"457\" srcset=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012009.png 568w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012009-300x241.png 300w\" sizes=\"auto, (max-width: 568px) 100vw, 568px\" \/><\/a><\/p>\n<p>This leads me to the conclusion, that task names should be chosen in a way that the displayed order of executed tasks corresponds to the actual execution order of the tasks. In addition to this there are two other commonly followed naming conventions for SSIS tasks:<\/p>\n<ol>\n<li>Use a meaningful numbering of tasks according to their actual execution order<\/li>\n<li>Use a prefix for each task type<\/li>\n<li>Use meaningful task names<\/li>\n<\/ol>\n<h2>Numbering of tasks according to their execution order<\/h2>\n<p>When thinking of a meaningful numbering of task names we should distinguish <strong>Control Flow Tasks<\/strong> from <strong>Data Flow Tasks<\/strong>.<\/p>\n<h3>Control Flow Tasks<\/h3>\n<p>Using Numbers as a prefix ensures that tasks will be logged in the right order according to the order of their execution.<\/p>\n<p>The numbering should support a four-digit range (numbers up to 9999). Smaller numbers should be entered with leading zeros. Don\u2019t use consecutive numbers. Leaving gaps between two numbers allows for changing the execution order of tasks by minimizing the effort for the modification of task names through adjusting the numbering.<\/p>\n<p>Of course, numbering tasks is time consuming, but the advantage outweighs the effort. The experiences made in multi developer projects prove to be beneficial when dealing with errors:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012005.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-541 size-large\" src=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012005-1024x324.png\" alt=\"\" width=\"1024\" height=\"324\" srcset=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012005-1024x324.png 1024w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012005-300x95.png 300w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012005-768x243.png 768w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012005.png 1133w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>The following execution result shows the execution plan of the above package. All tasks are ordered according to their task name. With that the execution log appears to be much more legible than the first version in this article:<\/p>\n<p><a href=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0011014.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-528 size-full\" src=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0011014.png\" sizes=\"auto, (max-width: 444px) 100vw, 444px\" srcset=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0011014.png 444w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0011014-165x300.png 165w\" alt=\"\" width=\"444\" height=\"807\" \/><\/a><\/p>\n<h3>Data Flow Tasks<\/h3>\n<p>The execution of Data Flow Tasks is normally not logged in the execution log, but it is recommended to apply a numbering convention to Data Flow Tasks, too. In fact, the convention should be extended as stated after the next screenshot.<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012011.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-547 size-full\" src=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012011.png\" alt=\"\" width=\"260\" height=\"172\" \/><\/a><\/p>\n<p>The first executed Control Flow Task was prefixed with the number <strong>0110<\/strong>. All Data Flow tasks should be prefixed with the same number followed by a numbering for all Data Flow Tasks. This allows an unambiguous identification of any Data Flow Task in a package. When using this naming convention all Data Flow Tasks are prefixed with two numbers:<\/p>\n<ul>\n<li>Control Flow Nummer<\/li>\n<li>Data Flow Nummer<\/li>\n<\/ul>\n<p>But in which situation proves this convention to be beneficial. In case of exceptions fired by a Data Flow Task SSIS logs the task name of the Data Flow Tasks that fired the exception. Unique names help to identify the task that has fired an exception:<\/p>\n<p style=\"padding-left: 30px;\"><a href=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012012.png\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-548 size-full\" src=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012012.png\" alt=\"\" width=\"643\" height=\"37\" srcset=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012012.png 643w, https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012012-300x17.png 300w\" sizes=\"auto, (max-width: 643px) 100vw, 643px\" \/><\/a><\/p>\n<h2>Use a prefix for each task typek<\/h2>\n<p>Each task type has its own pictogram. However, the representation of task types is limited to the size of icons which is 16\u00d716 pixel. Moreover, a pictogram is just a visual representation. The identification of task types in an execution log requires prefixes that indicate the type of a task.<\/p>\n<p>To increase the readability, it is therefore common sense that task names should be prefixed with an abbreviation depending on the task type:<\/p>\n<ul>\n<li><strong>DFT<\/strong> for <strong>Data Flow Task<\/strong><\/li>\n<li><strong>SCT<\/strong> for <strong>Script Task<\/strong><\/li>\n<li><strong>SQL<\/strong> for <strong>SQL Execute Task<\/strong><\/li>\n<li>\u2026<\/li>\n<\/ul>\n<p>The internet provides a few lists with suggestions for such abbreviations\/prefixes. The following two tables contain the abbreviations\/prefixes used by me.<\/p>\n<h3><a name=\"_Toc39699598\"><\/a>Prefixes for Control Flow Tasks<\/h3>\n<table width=\"500\">\n<colgroup>\n<col width=\"300\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/> <\/colgroup>\n<tbody>\n<tr>\n<td style=\"text-align: left;\"><strong>Task<\/strong><\/td>\n<td style=\"text-align: left;\"><strong>Prefix<\/strong><\/td>\n<td style=\"text-align: left;\"><strong>Typ<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Back Up Database Task<\/td>\n<td style=\"text-align: left;\"><strong>BACKUP<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">CDC Control Task<\/td>\n<td style=\"text-align: left;\"><strong>CDC<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Check Database Integrity Task<\/td>\n<td style=\"text-align: left;\"><strong>CHECKDB<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Data Profiling Task<\/td>\n<td style=\"text-align: left;\"><strong>DPT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Execute SQL Server Agent Job Task<\/td>\n<td style=\"text-align: left;\"><strong>AGENT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Execute T-SQL Statement Task<\/td>\n<td style=\"text-align: left;\"><strong>TSQL<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">History Cleanup Task<\/td>\n<td style=\"text-align: left;\"><strong>HISTCT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Maintenance Cleanup Task<\/td>\n<td style=\"text-align: left;\"><strong>MAINCT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Notify Operator Task<\/td>\n<td style=\"text-align: left;\"><strong>NOT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Rebuild Index Task<\/td>\n<td style=\"text-align: left;\"><strong>REBIT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Reorganize Index Task<\/td>\n<td style=\"text-align: left;\"><strong>REOIT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Shrink Database Task<\/td>\n<td style=\"text-align: left;\"><strong>SHRINKDB<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Update Statistics Task<\/td>\n<td style=\"text-align: left;\"><strong>STAT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">For Loop Container<\/td>\n<td style=\"text-align: left;\"><strong>FLC<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Foreach Loop Container<\/td>\n<td style=\"text-align: left;\"><strong>FELC<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Sequence Container<\/td>\n<td style=\"text-align: left;\"><strong>SEQC<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">ActiveX Script<\/td>\n<td style=\"text-align: left;\"><strong>AXS<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Analysis Services Execute DDL Task<\/td>\n<td style=\"text-align: left;\"><strong>ASE<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Analysis Services Processing Task<\/td>\n<td style=\"text-align: left;\"><strong>ASP<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Bulk Insert Task<\/td>\n<td style=\"text-align: left;\"><strong>BLK<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Data Flow Task<\/td>\n<td style=\"text-align: left;\"><strong>DFT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Data Mining Query Task<\/td>\n<td style=\"text-align: left;\"><strong>DMQ<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Execute Package Task<\/td>\n<td style=\"text-align: left;\"><strong>EPT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Execute Process Task<\/td>\n<td style=\"text-align: left;\"><strong>EPR<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Execute SQL Task<\/td>\n<td style=\"text-align: left;\"><strong>SQL<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Expression Task<\/td>\n<td style=\"text-align: left;\"><strong>EXPR<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">File System Task<\/td>\n<td style=\"text-align: left;\"><strong>FSYS<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">FTP Task<\/td>\n<td style=\"text-align: left;\"><strong>FTP<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Message Queue Task<\/td>\n<td style=\"text-align: left;\"><strong>MSMQ<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Script Task<\/td>\n<td style=\"text-align: left;\"><strong>SCR<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Send Mail Task<\/td>\n<td style=\"text-align: left;\"><strong>SMT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Transfer Database Task<\/td>\n<td style=\"text-align: left;\"><strong>TDB<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Transfer Error Messages Task<\/td>\n<td style=\"text-align: left;\"><strong>TEM<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Transfer Jobs Task<\/td>\n<td style=\"text-align: left;\"><strong>TJT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Transfer Logins Task<\/td>\n<td style=\"text-align: left;\"><strong>TLT<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Transfer Master Stored Procedures Task<\/td>\n<td style=\"text-align: left;\"><strong>TSP<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Transfer SQL Server Objects Task<\/td>\n<td style=\"text-align: left;\"><strong>TSO<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Web Service Task<\/td>\n<td style=\"text-align: left;\"><strong>WST<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">WMI Data Reader Task<\/td>\n<td style=\"text-align: left;\"><strong>WMID<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">WMI Event Watcher Task<\/td>\n<td style=\"text-align: left;\"><strong>WMIE<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">XML Task<\/td>\n<td style=\"text-align: left;\"><strong>XML<\/strong><\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><a name=\"_Toc39699599\"><\/a>Prefixes for Data Flow Tasks<\/h3>\n<table width=\"600\">\n<colgroup>\n<col width=\"300\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/>\n<col width=\"100\" \/> <\/colgroup>\n<tbody>\n<tr>\n<td><strong>Task<\/strong><\/td>\n<td><strong>Prefix<\/strong><\/td>\n<td><strong>Type<\/strong><\/td>\n<td><strong>Supplier<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">ADO NET Source<\/td>\n<td style=\"text-align: left;\"><strong>ADO_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Azure Blob Source<\/td>\n<td style=\"text-align: left;\"><strong>AB_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">CDC Source<\/td>\n<td style=\"text-align: left;\"><strong>CDC_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">DataReader Source<\/td>\n<td style=\"text-align: left;\"><strong>DR_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Excel Source<\/td>\n<td style=\"text-align: left;\"><strong>EX_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Flat File Source<\/td>\n<td style=\"text-align: left;\"><strong>FF_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">HDFS File Source<\/td>\n<td style=\"text-align: left;\"><strong>HDFS_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">OData Source<\/td>\n<td style=\"text-align: left;\"><strong>ODATA_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">ODBC Source<\/td>\n<td style=\"text-align: left;\"><strong>ODBC_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">OLE DB Source<\/td>\n<td style=\"text-align: left;\"><strong>OLE_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Raw File Source<\/td>\n<td style=\"text-align: left;\"><strong>RF_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SharePoint List Source<\/td>\n<td style=\"text-align: left;\"><strong>SPL_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">XML Source<\/td>\n<td style=\"text-align: left;\"><strong>XML_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Aggregate<\/td>\n<td style=\"text-align: left;\"><strong>AGG<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Audit<\/td>\n<td style=\"text-align: left;\"><strong>AUD<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Balanced Data Distributor<\/td>\n<td style=\"text-align: left;\"><strong>BDD<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Cache Transform<\/td>\n<td style=\"text-align: left;\"><strong>CCH<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">CDC Splitter<\/td>\n<td style=\"text-align: left;\"><strong>CDCS<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Character Map<\/td>\n<td style=\"text-align: left;\"><strong>CHM<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Conditional Split<\/td>\n<td style=\"text-align: left;\"><strong>CSPL<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Copy Column<\/td>\n<td style=\"text-align: left;\"><strong>CPYC<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Data Conversion<\/td>\n<td style=\"text-align: left;\"><strong>DCNV<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Data Mining Query<\/td>\n<td style=\"text-align: left;\"><strong>DMQ<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Derived Column<\/td>\n<td style=\"text-align: left;\"><strong>DER<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">DQS Cleansing<\/td>\n<td style=\"text-align: left;\"><strong>DQSC<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Export Column<\/td>\n<td style=\"text-align: left;\"><strong>EXPC<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Fuzzy Grouping<\/td>\n<td style=\"text-align: left;\"><strong>FZG<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Fuzzy Lookup<\/td>\n<td style=\"text-align: left;\"><strong>FZL<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Import Column<\/td>\n<td style=\"text-align: left;\"><strong>IMPC<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Lookup<\/td>\n<td style=\"text-align: left;\"><strong>LKP<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Merge<\/td>\n<td style=\"text-align: left;\"><strong>MRG<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Merge Join<\/td>\n<td style=\"text-align: left;\"><strong>MRGJ<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Multicast<\/td>\n<td style=\"text-align: left;\"><strong>MLT<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">OLE DB Command<\/td>\n<td style=\"text-align: left;\"><strong>CMD<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Percentage Sampling<\/td>\n<td style=\"text-align: left;\"><strong>PSMP<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Pivot<\/td>\n<td style=\"text-align: left;\"><strong>PVT<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Row Count<\/td>\n<td style=\"text-align: left;\"><strong>CNT<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Row Sampling<\/td>\n<td style=\"text-align: left;\"><strong>RSMP<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Script Component<\/td>\n<td style=\"text-align: left;\"><strong>SCR<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Slowly Changing Dimension<\/td>\n<td style=\"text-align: left;\"><strong>SCD<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Sort<\/td>\n<td style=\"text-align: left;\"><strong>SRT<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Term Extraction<\/td>\n<td style=\"text-align: left;\"><strong>TEX<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Term Lookup<\/td>\n<td style=\"text-align: left;\"><strong>TEL<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Union All<\/td>\n<td style=\"text-align: left;\"><strong>ALL<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Unpivot<\/td>\n<td style=\"text-align: left;\"><strong>UPVT<\/strong><\/td>\n<td style=\"text-align: left;\">Transformation<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">ADO NET Destination<\/td>\n<td style=\"text-align: left;\"><strong>ADO_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Azure Blob Destination<\/td>\n<td style=\"text-align: left;\"><strong>AB_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Data Mining Model Training<\/td>\n<td style=\"text-align: left;\"><strong>DMMT_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Data Streaming Destination<\/td>\n<td style=\"text-align: left;\"><strong>DS_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">DataReaderDest<\/td>\n<td style=\"text-align: left;\"><strong>DR_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Dimension Processing<\/td>\n<td style=\"text-align: left;\"><strong>DP_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Excel Destination<\/td>\n<td style=\"text-align: left;\"><strong>EX_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Flat File Destination<\/td>\n<td style=\"text-align: left;\"><strong>FF_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">HDFS File Destination<\/td>\n<td style=\"text-align: left;\"><strong>HDFS_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">ODBC Destination<\/td>\n<td style=\"text-align: left;\"><strong>ODBC_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">OLE DB Destination<\/td>\n<td style=\"text-align: left;\"><strong>OLE_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Partition Processing<\/td>\n<td style=\"text-align: left;\"><strong>PP_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Raw File Destination<\/td>\n<td style=\"text-align: left;\"><strong>RF_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Recordset Destination<\/td>\n<td style=\"text-align: left;\"><strong>RS_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SharePoint List Destination<\/td>\n<td style=\"text-align: left;\"><strong>SPL_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SQL Server Compact Destination<\/td>\n<td style=\"text-align: left;\"><strong>SSC_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">SQL Server Destination<\/td>\n<td style=\"text-align: left;\"><strong>SS_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\"><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Microsoft Dynamics 365 CE\/CRM Source<\/td>\n<td style=\"text-align: left;\"><strong>CRM_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\">KingswaySoft Software<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Microsoft Dynamics 365 CE\/CRM Destination<\/td>\n<td style=\"text-align: left;\"><strong>CRM_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\">KingswaySoft Software<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Oracle Eloqua Source<\/td>\n<td style=\"text-align: left;\"><strong>ELO_SRC<\/strong><\/td>\n<td style=\"text-align: left;\">Source<\/td>\n<td style=\"text-align: left;\">KingswaySoft Software<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: left;\">Oracle Eloqua Destination<\/td>\n<td style=\"text-align: left;\"><strong>ELO_DST<\/strong><\/td>\n<td style=\"text-align: left;\">Destination<\/td>\n<td style=\"text-align: left;\">KingswaySoft Software<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>Task names<\/h2>\n<p>Finally, task names should briefly describe what the task does. For example, Import Customer, Check Data Types, etc.<\/p>\n<h2>Naming Convention<\/h2>\n<p>All tasks (Control Flow Tasks and Data Flow Tasks) within a SSIS package should have a unique name. The following naming convention provides a rule for specifying a unique name:<\/p>\n<p><strong>XXXX [YYYY] ZZZ Name<\/strong><\/p>\n<p>with<\/p>\n<p><strong>XXXX<\/strong><\/p>\n<ul>\n<li>Numbering of Control Flow Tasks.<\/li>\n<li>The numbering of Control Flow Tasks should support a four-digit number range (up to 9999).<\/li>\n<li>Smaller numbers should be prefixed with leading zeros.<\/li>\n<li>Don\u2019t use consecutive numbers. Leaving gaps between two numbers allows for changing the execution order of tasks by minimizing the effort for the modification of task names through adjusting the numbering.<\/li>\n<\/ul>\n<p><strong>YYYY<\/strong><\/p>\n<ul>\n<li>Numbering of Data Flow Tasks.<\/li>\n<li>The numbering of Data Flow Tasks contains as a prefix the number of the containing Control Flow Task with type of Data Flow (<strong>XXXX<\/strong>).<\/li>\n<li>The numbering of Data Flow Tasks should support a four-digit number range (up to 9999).<\/li>\n<li>Smaller numbers should be prefixed with leading zeros.<\/li>\n<li>Don\u2019t use consecutive numbers. Leaving gaps between two numbers allows for changing the execution order of tasks by minimizing the effort for the modification of task names through adjusting the numbering.<\/li>\n<\/ul>\n<p><strong>ZZZ<\/strong><\/p>\n<ul>\n<li>Prefix that allows identifying the type of a Control Flow or Data Flow Task.<\/li>\n<li>Refer to the above given prefixes.<\/li>\n<\/ul>\n<p><strong>Name<\/strong><\/p>\n<ul>\n<li>Task names should briefly describe what the task does.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Overview The definition of programming guidelines and naming conventions only makes sense if the advantage outweighs the effort. One important prerequisite for this is the identification of the benefits. Readability and maintainability of code are generally in the focus of developers when talking about naming conventions. In case of SQL Server Integration Services (SSIS), however, &#8230; <a title=\"Naming convention for SSIS Tasks\" class=\"read-more\" href=\"https:\/\/staging.sql.marcus-belz.de\/?p=533&#038;lang=en\" aria-label=\"Mehr Informationen \u00fcber Naming convention for SSIS Tasks\">Weiterlesen<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[106,108],"tags":[144,152,138],"class_list":["post-533","post","type-post","status-publish","format-standard","hentry","category-all-languages-en","category-english-en","tag-multi-developer-environment-en","tag-naming-convention-en","tag-ssis-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Naming convention for SSIS Tasks - Just another SQL blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Naming convention for SSIS Tasks - Just another SQL blog\" \/>\n<meta property=\"og:description\" content=\"Overview The definition of programming guidelines and naming conventions only makes sense if the advantage outweighs the effort. One important prerequisite for this is the identification of the benefits. Readability and maintainability of code are generally in the focus of developers when talking about naming conventions. In case of SQL Server Integration Services (SSIS), however, ... Weiterlesen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/staging.sql.marcus-belz.de\/?p=533&amp;lang=en\" \/>\n<meta property=\"og:site_name\" content=\"Just another SQL blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-24T14:40:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-06T23:06:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001-1024x324.png\" \/>\n<meta name=\"author\" content=\"marcus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschrieben von\" \/>\n\t<meta name=\"twitter:data1\" content=\"marcus\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"9\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en\"},\"author\":{\"name\":\"marcus\",\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/#\\\/schema\\\/person\\\/98ab042e47d7286f64530ee18f20f675\"},\"headline\":\"Naming convention for SSIS Tasks\",\"datePublished\":\"2018-06-24T14:40:04+00:00\",\"dateModified\":\"2026-05-06T23:06:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en\"},\"wordCount\":1706,\"image\":{\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/post0012001-1024x324.png\",\"keywords\":[\"Multi Developer Environment\",\"Naming Convention\",\"SSIS\"],\"articleSection\":[\"All Languages\",\"English\"],\"inLanguage\":\"de\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en\",\"url\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en\",\"name\":\"Naming convention for SSIS Tasks - Just another SQL blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/post0012001-1024x324.png\",\"datePublished\":\"2018-06-24T14:40:04+00:00\",\"dateModified\":\"2026-05-06T23:06:39+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/#\\\/schema\\\/person\\\/98ab042e47d7286f64530ee18f20f675\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en#primaryimage\",\"url\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/post0012001.png\",\"contentUrl\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/post0012001.png\",\"width\":1133,\"height\":358},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?p=533&lang=en#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Naming convention for SSIS Tasks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/#website\",\"url\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/\",\"name\":\"Just another SQL blog\",\"description\":\"Marcus Belz \u00b7 SQL Server \u00b7 ETL \u00b7 Datenqualit\u00e4t\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/#\\\/schema\\\/person\\\/98ab042e47d7286f64530ee18f20f675\",\"name\":\"marcus\",\"url\":\"https:\\\/\\\/staging.sql.marcus-belz.de\\\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Naming convention for SSIS Tasks - Just another SQL blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en","og_locale":"de_DE","og_type":"article","og_title":"Naming convention for SSIS Tasks - Just another SQL blog","og_description":"Overview The definition of programming guidelines and naming conventions only makes sense if the advantage outweighs the effort. One important prerequisite for this is the identification of the benefits. Readability and maintainability of code are generally in the focus of developers when talking about naming conventions. In case of SQL Server Integration Services (SSIS), however, ... Weiterlesen","og_url":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en","og_site_name":"Just another SQL blog","article_published_time":"2018-06-24T14:40:04+00:00","article_modified_time":"2026-05-06T23:06:39+00:00","og_image":[{"url":"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001-1024x324.png","type":"","width":"","height":""}],"author":"marcus","twitter_card":"summary_large_image","twitter_misc":{"Geschrieben von":"marcus","Gesch\u00e4tzte Lesezeit":"9\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en#article","isPartOf":{"@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en"},"author":{"name":"marcus","@id":"https:\/\/staging.sql.marcus-belz.de\/#\/schema\/person\/98ab042e47d7286f64530ee18f20f675"},"headline":"Naming convention for SSIS Tasks","datePublished":"2018-06-24T14:40:04+00:00","dateModified":"2026-05-06T23:06:39+00:00","mainEntityOfPage":{"@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en"},"wordCount":1706,"image":{"@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en#primaryimage"},"thumbnailUrl":"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001-1024x324.png","keywords":["Multi Developer Environment","Naming Convention","SSIS"],"articleSection":["All Languages","English"],"inLanguage":"de"},{"@type":"WebPage","@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en","url":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en","name":"Naming convention for SSIS Tasks - Just another SQL blog","isPartOf":{"@id":"https:\/\/staging.sql.marcus-belz.de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en#primaryimage"},"image":{"@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en#primaryimage"},"thumbnailUrl":"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001-1024x324.png","datePublished":"2018-06-24T14:40:04+00:00","dateModified":"2026-05-06T23:06:39+00:00","author":{"@id":"https:\/\/staging.sql.marcus-belz.de\/#\/schema\/person\/98ab042e47d7286f64530ee18f20f675"},"breadcrumb":{"@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en#primaryimage","url":"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001.png","contentUrl":"https:\/\/staging.sql.marcus-belz.de\/wp-content\/uploads\/2018\/06\/post0012001.png","width":1133,"height":358},{"@type":"BreadcrumbList","@id":"https:\/\/staging.sql.marcus-belz.de\/?p=533&lang=en#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/staging.sql.marcus-belz.de\/"},{"@type":"ListItem","position":2,"name":"Naming convention for SSIS Tasks"}]},{"@type":"WebSite","@id":"https:\/\/staging.sql.marcus-belz.de\/#website","url":"https:\/\/staging.sql.marcus-belz.de\/","name":"Just another SQL blog","description":"Marcus Belz \u00b7 SQL Server \u00b7 ETL \u00b7 Datenqualit\u00e4t","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/staging.sql.marcus-belz.de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Person","@id":"https:\/\/staging.sql.marcus-belz.de\/#\/schema\/person\/98ab042e47d7286f64530ee18f20f675","name":"marcus","url":"https:\/\/staging.sql.marcus-belz.de\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=\/wp\/v2\/posts\/533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=533"}],"version-history":[{"count":10,"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=\/wp\/v2\/posts\/533\/revisions"}],"predecessor-version":[{"id":949,"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=\/wp\/v2\/posts\/533\/revisions\/949"}],"wp:attachment":[{"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/staging.sql.marcus-belz.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}