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

Tim Mitchell gravatar image

Tim Mitchell
23 2 2 3

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

3 answers: sort oldest

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

Scott Thornburg gravatar image

Scott Thornburg

(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

Rob Farley gravatar image

Rob Farley
5.7k 16 18 20

I agree. I am particular with my naming conventions for database objects and columns, but my SSIS task names look more like descriptive labels than anything else.
Oct 22, 2009 at 03:23 AM Tom Staab
As SSIS is a drag-and-drop interface, I think there's a little less reason to have a particular naming convention. You look at it graphically. If you hook into the XML itself, you have the types available in other ways.
Oct 22, 2009 at 04:11 AM Rob Farley
(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

SharkEnergy gravatar image

11 1 1 1

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 3610 times

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