.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

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

Posted By:Karthikeyan Anbarasan       Posted Date: March 21, 2011    Points: 200    Category: DataBase    URL: http://www.dotnetspark.com  

In this article we are going to see on the folder structure used in deploying the SSIS package and the usage of those folders in SQL Server Integration Services (SSIS)
 

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.To follow my series of articles on

SSIS packages refer to the below URL's

Basics of SSIS and Creating Package - SQL Server Integration Services (SSIS) - Part 1

Transforming SQL Data to Excel Sheet - SQL Server Integration Services (SSIS) - Part 2

Export Data using Wizard - SQL Server Integration Services (SSIS) - Part 3

Import Data using Wizard - SQL Server Integration Services (SSIS) - Part 4

Building and Executing a Package - SQL Server Integration Services (SSIS) - Part 5

Options to execute a package in SSIS - SQL Server Integration Services (SSIS) - Part 6 

Options to Deploy a package in SSIS - SQL Server Integration Services (SSIS) - Part 7

Scripting in SSIS Packages - SQL Server Integration Services (SSIS) - Part 8

Breakpoints in SSIS Packages - SQL Server Integration Services (SSIS) - Part 9

Check Points in SSIS Packages - SQL Server Integration Services (SSIS) - Part 10

Send Mail in SSIS Packages - SQL Server Integration Services (SSIS) - Part 11

For Loop task in SSIS Packages - SQL Server Integration Services (SSIS) - Part 12

Backup Database task in SSIS and Send Mail - SQL Server Integration Services (SSIS) - Part 13


SSIS Folder Struture

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.

 Subscribe to Articles

     

Further Readings:

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend