Formed in 2009, the Archive Team (not to be confused with the archive.org Archive-It Team) is a rogue archivist collective dedicated to saving copies of rapidly dying or deleted websites for the sake of history and digital heritage. The group is 100% composed of volunteers and interested parties, and has expanded into a large amount of related projects for saving online and digital history.
Mass Street Analytics ETL Framework
This is a framework for moving data into a data warehouse. It includes everything you need to set up a self-service data platform.
This is the system that is used when Mass Street resources are tasked with implementing data warehouses. The framework has been in development since 2011. It is currently powering the analytics for several small to medium sized firms with anywhere from a few hundred GBs to several TBs of historical data.
There should be ZERO references to any specific system or database aside from Reporting and ODS. If you should find such a reference, please log an issue.
The following links may be helpful in setting up your environment.
Grant SELECT permission on a view, but not on underlying objects
Grant Select on a view not base table when base table is in a different database
How to setup SQL Server alerts and email operator notifications
Create a Database Mail Profile
Configure SQL Server Agent Mail to Use Database Mail
Running a SSIS Package from SQL Server Agent Using a Proxy Account