SSIS Object Naming Conventions

Does anyone have recommendations for SSIS object naming conventions? I've been using a seat-of-my-pants methodology, with few standards. I'm curious what other shops are doing.

Thanks! Tim

more ▼

asked Oct 21, 2009 at 11:57 PM in Default

avatar image

Tim Mitchell
23 2 2 5

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

Back in 2006, Jamie Thomson (a SQL Server MVP for SSIS) published a set of best practices and naming conventions for tasks and components

Object Naming Conventions:


These have become fairly popular and may be the source of some of the "Hungarian"-like names for SSIS objects. In the SSIS graphical environment, the icons typically indicate what the object is, and the naming conventions don't seem to serve much value. However, there is value in when the full name is reported in error logs. This makes it possible to easily identify the type of task/component that is reporting the error.

Beyond this, the most important criteria for a good naming convention is consistent use throughout all your packages.

more ▼

answered Nov 11, 2009 at 01:49 AM

avatar image

Scott Thornburg
37 2 1

(comments are locked)
10|1200 characters needed characters left

I know a few places that insist on using "DFT ..." for Data Flow Tasks, and so on. Personally, I'm not as much of a fan of having a particular naming convention as I am having sensible names, and appropriate descriptions. And useful annotations where possible.

more ▼

answered Oct 22, 2009 at 12:02 AM

avatar image

Rob Farley
5.8k 16 22 28

(comments are locked)
10|1200 characters needed characters left

In the MCTS for BI they were all DFT this and SMTP that and so on. I tend to go against this now I am doing my own thing which is generally just a really good descriptive label.

more ▼

answered Nov 10, 2009 at 06:40 PM

avatar image

11 1 1 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 21, 2009 at 11:57 PM

Seen: 3991 times

Last Updated: Oct 22, 2009 at 05:58 AM

Copyright 2018 Redgate Software. Privacy Policy