SQL Server Integration Services (SSIS) - Folder Structure in SSIS

In this article I shall describe the folder structure used in deploying the SSIS package and the usage of those folders.

Introduction

In this article we are going to see the folder structure used in deploying the SSIS package and the usage of those folders.

SSIS Folder Struture

Whenever we create a SSIS package and we have completed our development and finally deploy the package we need to follow a folder structure which is normal for us to follow. Let's go in depth and see the different folders used and the purpose of each one. 

Normally all the folders should reside under a single folder which can be of any custom name. Under this root folder we can have a number of sub-folders as described below:

Packages: All the packages can be placed in this folder. This will be the main folder.
Project: This is the sub-folder of Packages, which contains all the SSIS package files and Configuration files for each project deployed.
WorkFiles: This is a temporary folder; files used to import or export or any log files can be placed in this folder.
Project: This is the sub-folder of Workfiles folder which is used for the same purpose as above and also they can have any logs, data received for import, or data exported
Archive: This is the sub-folder of Project folder, after a file has been imported that file will be dated and placed in this folder
Logs: This is the sub-folder of Project folder, Log files generated for SSIS package and SQL Agent jobs are placed here
Response: This is the sub-folder of Project folder, Rejected process of data imported file will go to this folder
Temporary: This is the sub-folder of Project folder, Raw files generated during the package execution will be placed in this folder

Conclusion

This article explains the purpose of the different folders used in the deployment of SSIS package and how to use them effectively.