Tag Archives: Data mapping

List all tables and columns in database

In a recent data warehouse project we had to do source to target mappings (STTM) for our ETL. I want to return a list of all tables with their supporting information such as schema’s, columns and data types. Something similar … Continue reading

Posted in SQL Server 2012 | Tagged , | Leave a comment

SQL Server data types in .Net Framework

The good folks at Microsoft did a wonderful job at providing us with a SQL Server data type mapping for the .Net Framework. This is especially useful when you are working with SSIS or have some BimlScript. I used it … Continue reading

Posted in SQL Server 2014 | Tagged , , , | Leave a comment