About the BI Monkey SSIS ETL Framework

The BI Monkey SSIS ETL Framework is an ETL Execution, Control and Logging system for ETL projects using SSIS. It is supported by a SQL Server metadata database.

It is created by James Beresford, SSIS & MS BI Blogger at http://www.bimonkey.com

The project is released as the v1 framework for SQL2005+. The v1 framework is simple and suited to smaller deployments. The v1 release currently is in Beta and is ready to use. It remains in Beta purely because the reporting side is not complete at this point. The v2 version is now unlikely to be released on codeplex and will only be available in a commercial form.

A commercially supported version is now available at http://www.bimonkey.com/framework/ for SQL2012+ in versions equivalent to v1 and v2.

Framework v1

The v1 Framework described below is the initial, simple release that is suited to simple linear processes in single server environments. It supports the following execution features, all of which are configurable at the metadata level:

The Framework consists of:

Framework v2

The v2 Framework will be a more industrial level framework which will add the following features: