BI Builder for SQL Server
BI Builder is a pure T-SQL application for MSSQL data warehouse developers: It generates staging and dimension tables as well as ETL stored procedures.Designed for ease of use and customisation, BIB has one stored procedure that you run to build your database layers and ETL procedures.
BI Builder itself is composed of a series of modular stored procedures and scalar functions that you can modify to suit your style of building data warehouses.
BI Builder comes with examples and a developer guide and has been tested on MSSQL versions 2008R2, 2012 and 2014 CTP.
You can find BI Builder for SQL Server on Codeplex at http://bibuilder.codeplex.com