x

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 '09 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 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:

http://consultingblogs.emc.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Suggested-Best-Practices-and-naming-conventions.aspx

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 '09 at 01:49 AM

Scott Thornburg gravatar image

Scott Thornburg
37

(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 '09 at 12:02 AM

Rob Farley gravatar image

Rob Farley
5.7k 15 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 '09 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 '09 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 '09 at 06:40 PM

SharkEnergy gravatar image

SharkEnergy
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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x900
x61

asked: Oct 21 '09 at 11:57 PM

Seen: 3307 times

Last Updated: Oct 22 '09 at 05:58 AM