Back to Home

SSIS Guide

• Overview
• SSIS Package Folder Structure

Overview

This document contains useful information about SSIS packages.

SSIS Package Folder Structure

Main Folder:

\\SQLSERVERNAME\CORE_CEM_SSIS

Subfolders:

• LogFiles - Stores log files that are produced from the SSIS package running.
• Packages - Stores dstx files. This is where the SSIS packages live.
• ConfigFiles - Stores the config files for each job that gets run via BMRS/ESP. These config files let us override any variables in the SISS packages, such as connection string.
• TWSFiles - Stores command files that actually run the SSIS package. The command file executes the dtsx file with the relevant arguments for dtsx file, config file, and log file.