How do you organize your SSIS projects?

Question

Post reply

How do you organize your SSIS projects?

Scott In Sydney

Hall of Fame

Points: 3331

October 4, 2019 at 5:17 am

Go to Answer

#3685905

Hi,

I'm currently organizing/deploying my SSIS projects as:

Integration Services Catalogs
   SSISDB
      Folder name matching the Project name
         Projects
            Project name
               Packages
                  Package name.dtsx
            Environments
               Development
               Production

Using this structure, I have to create an environment for each folder.

We only have a small number of servers and databases. It occurred to me that I could create an "uber" environment, with all the server and database names, regardless of whether a particular project uses that server and/or database.

The structure could look something like:

Integration Services Catalogs
   SSISDB
      CompanyName Projects (eg. Acme Projects) or just CompanyName (eg. Acme)
         Projects
            ProjectA
            ProjectB
            ProjectC
            ProjectX
         Environments
            Development
            Production

I would then only have to create the environments once. And, if the environment did ever change, I only have to modify it in one spot, and the change propagates to all the projects.

Your thoughts?

Phil Parkin

SSC Guru

Points: 246986
More actions
October 4, 2019 at 1:45 pm
Answer
#3686030

Yes, that's the way to go.
Though having Development and Production on the same server makes me shudder.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Scott In Sydney Hall of Fame Points: 3331 More actions · Answer 1

Phil Parkin wrote:

Yes, that's the way to go.
Though having Development and Production on the same server makes me shudder.

~~Me too...I have idiot DBA's.~~

I agree

Scott In Sydney Hall of Fame Points: 3331 More actions · Answer 2

I did think of one other approach:

Integration Services Catalogs
   SSISDB
      #Environments (just so this would sort as the top folder)
         Projects
            Don't put any projects here
         Environments (Global environments that could apply to any/most projects)
            Development
            Production
      Folder name (may or may not match the Project name)
         Projects
            Project name
               Packages
                  Package name.dtsx
            Project name
               Packages
                  Package name.dtsx
            Project name
               Packages
                  Package name.dtsx
            Environments
               Don't put any environments here unless specific to this project/folder
      Folder name #2
         Projects
            Project name
               Packages
                  Package name.dtsx
      Etc.