This is part 14 of the series of article on 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 on the folder structure used in deploying the SSIS package and the usage of those folders.

You can look into my series of article on SSIS at the url – https://f5debug.net/tutorial/ssis.php

SSIS Folder Structure

When ever we create a SSIS package and we completed with our development task and finally to deploy the package we need to follow some folder structure which normal we used to follow. Lets go in depth and see the different folders used and the purpose of each one.
Normally all the folder should reside under a single folder which can be of any custom name. Under this root folder we can have number if sub folders as 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 prokect deployed
WorkFiles: This is a temporary folder, the file which are used to import or export or any log files can be placed in this folder.
Project: This is the subfolder 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 subfolder of Project folder, after a file has been imported that file will be dated and placed in this folder
Logs: This is the subfolder of Project folder, Log files generated for SSIS package and SQL Agent jobs are placed here
Response: This is the subfolder of Project folder, Rejected process of data imported file will go to this folder
Temporary: This is the subfolder of Project folder, Raw files generated during the package execution will be placed in this folder

Conclusion

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