SSIS Variable Naming Convention/Standard

Question

SSIS Variable Naming Convention/Standard

Bobby P 231

I know this is a very loose ended question/request...But just wondering what some of you use as Variable Naming Conventions/Standards when creating and using your SSIS Variables.

Just looking for some ideas of what some people and shops use for their SSIS Variable Naming Convention/Standard.

Thanks in advance for your review and am hopeful for some good, quality responses.

1 answer

Your answer

Answer 1

Azar 31,145 MVP Volunteer Moderator

Hi there Bobby P

Thanks for using QandA platform

use consistent, descriptive, and scoped-based prefixes for SSIS variable names. This make packages easier to read and maintain.

Prefix by scope: pkg_ (package-level), tsk_ (task-level), cnt_ (container-level).

Prefix by type: int_, str_, dt_, obj_, etc.

Descriptive name: Use meaningful names that describe purpose, e.g., str_SourceFilePath, int_RowCount, dt_ExecutionStart.

eg: pkg_str_ConnectionString, tsk_int_ErrorCode

If this helps kindly accept the answer thanks much

Akhil Gajavelly 645 Reputation points Microsoft External Staff Moderator

2025-10-31T06:19:03.6833333+00:00

Hi @Bobby P,

Thanks for the clear explanation @Azar and structured approach this is really helpful.

@Bobby P, please try following the suggested naming pattern using scope- and type-based prefixes (like pkg_str_ConnectionString or tsk_int_ErrorCode). It should make your SSIS packages much easier to manage and understand.

Thanks,
Akhil.

Share via

SSIS Variable Naming Convention/Standard

1 answer

Your answer