What's In The Box
This is a high level breakdown of the contents of the etl-framework folder.
Last updated
This is a high level breakdown of the contents of the etl-framework folder.
Last updated
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.