What's In The Box

This is a high level breakdown of the contents of the etl-framework folder.

Folder Name

Contents

ETL Framework Template

The SSIS package that serves as the template for any ETL processes that use SSIS.

Framework Deployment Scripts

All the scripts necessary to deploy the framework in your environment.

Rapid Development Tools

I feel the need. The need...FOR SPEED! Which is why I created all this stuff in the first place. This folder contains tools that allow you to rapidly design, develop, and implement data warehouses. There are tools that allow you to easily and quickly create data warehouse documentation like crosswalks and data dictionaries. There are SQL script creation tools that allow you to rapidly analyze data, build tables, and views.

If you take NOTHING else from this framework, you WANT what is in this folder.

Sample Directory Structures

A ready made out of the box file structures for code repos and file processing.

Sample Scripts

Scripts that allow you to perform various ETL task. The scripts frequently allow you to build complex processes with no more work than a little cutting and pasting of the columns you want to use.

Last updated