SSIS Package Naming Convention

Question

So we are having a debate in our IT Department on naming SSIS Packages...the Good Ole "Chicken or the egg" debate...

Should we name our SSIS Packages separating by an underscore "_" or a hyphen "-" for readability...

I have seen some arguments that any Microsoft Entity should NOT contain hyphens("-") because of the way that Microsoft interprets them...something to do with "En dash" and "Em dash"

I guess why I have always been told to use underscores "_" when naming SQL Server Entities, SQL Server Stored Procedures, etc..

Just wondering if that holds true for naming SSIS Packages and what is widely used as a Standard, Convention for naming SSIS Packages and your .dtsx file.

Thanks in advance for your time and hopeful for some replies.

Answer 1

Hi @Bobby P ,

There is no standard for Naming conventions.

The purpose of using naming convention in package is to insure consistency across the development teams and projects. As per my understanding, to use a good naming convention, please refer to the following tips:

1.To help formalize expectations and promote consistency within a development team.
2.Make it much easier to quickly view a project/package in SSIS.

I test that use underscores in package name or not will not affect the SSIS package, so the Naming convention is just depends on you and your teams. You can discuss with your colleagues to make better choice based on the requirement.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Thanks Zoehui-MSFT for your input...but I was more or less looking for opinions on my post and what other shops established for their naming convention. Just trying to do what makes sense and what seems to be most acceptable and avoid any landmines in the process.

I guess to be consistent, maybe we ought to go with underscores "_" to separate and make more readable base on my earlier post regarding hyphens "-" and how they are interpreted as "En Dash" and/or "Em dash" to avoid any FOEPAs