Monthly Archives: April 2009

Meta Database – Control Tables

The control tables within the meta database will not be uniform across the various instances running this framework.  I envision this schema being used for the various job processing tables that direct workflow, enumerate list items, or other general information … Continue reading

Posted in SSIS | Tagged , | Leave a comment

Meta Database – Data Quality

The Data Quality tables of the META database are used to store the screens used to identify records or tables which fail a data quality check.  These tables are further used to store each of these failure occurrences and the … Continue reading

Posted in SSIS | Tagged , | Leave a comment

Meta Database – Audit Tables

The Audit tables in the META database are used to track the statistics of package executions.  Packages The Packages table stores information relating to the package name and versions which are executing.  The packages table has one record per package … Continue reading

Posted in SSIS | Tagged , | Leave a comment

Meta Database – Data Dictionary

The Data Dictionary is a set of tables used to describe other tables.  In this case, I have split the data dictionary into three tables: TableDictionary, ColumnDictionary and LogicalDataMap.  TableDictionary The table dictionary is used to describe data about the … Continue reading

Posted in SSIS | Tagged , | 2 Comments

Meta Database

During the next few weeks I will be posting articles relating to the Meta Database.  This database is used to house information relating to the following topics: Data Dictionary – A repository of information which describes the tables,  views and … Continue reading

Posted in SSIS | Tagged , | Leave a comment

More SQL Saturdays

I have just found out that I will be speaking at the SQL Saturday #14 in Pensacola on June 6, 2009.  I will be doing my SSIS: Expressions, Configurations and Constraints presentation. As a quick aside, here is the run … Continue reading

Posted in SQL | Tagged , | Leave a comment

SQL Saturday #15 – Jacksonville, FL 02 May 2009

I will be presenting two sessions at the upcoming SQL Saturday on May 2, 2009 in Jacksonville FL. SSIS – Beginner’s Walkthrough9:00 AM This session will step the attendees through the basics of SSIS by setting up a sample solution … Continue reading

Posted in SQL | Tagged , | 2 Comments