Floating FB popout byF5debug

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

 

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 - http://f5debug.net/tutorial/ssis.aspx

[more]

 

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.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (1) -

HongNgoc
HongNgoc
8/23/2013 8:50:59 PM #

Thank you so much. Your posts very helpful for me. But I have small proble when I executed this package (same with your example parkage), package finished but no rows is inserted to tables. Please help me to solve it .
Thanks.

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter