Follow

When and why to use SSIS folders

TX DWA allows you to enable two kinds of SSIS folders: project-level SSIS folders, and environment-level SSIS folders.  In order to prevent a number of unusual errors, it's important to use these folders when necessary.

SSIS - a server level entity

The reason SSIS folders exist is because SSIS packages are not database specific.  Instead, they are stored at the server level, and by default all occupy the same root folder.  If you have just one project in just one environment, this is not a problem.  However, once you introduce more than one project or more than one environment, conflicts can occur.  

This is because TX DWA names SSIS packages in a deterministic way that is not specific to a project or environment.  If the same table name appears in more than one place, TX DWA will overwrite the package whenever the table is deployed in either project.

Project specific folders

Creating small, ad-hoc projects is a great way to test things out.  If you do this, though, you need to be cautious.  If you are using the same data source in more than one project, you must give the data source a different prefix in each project, and avoid reusing any custom table or data warehouse table names across all of your projects.  

Alternately, if you enable project specific SSIS folders on all of your projects, you will be able to name all of your tables anything you want without worrying about SSIS conflicts.  Note that this option does require Windows authentication to work.  Project specific SSIS folders can be enabled under your project settings, as shown here:

Project_Folders.png

Environment specific folders

It may or may not be necessary to create environment-specific folders, even if you have multiple environments.  In order to find out if you should enable this option, determine whether or not more than one environment will ever be on hosted on the same server at any given time.  

If the answer is a very definite "no," then you do not have to enable this option.  If the answer is "yes," or "maybe," be sure to turn this on for all environments!  Environment specific SSIS folders can be turned on under Environment Properties environment settings, as shown here:

Environment_Folders.png

 

Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.