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 to build dynimic data conversion rules into my BIML solution which creates my staging area.
You can find the details here.
- Follow Big Data and Analytics on WordPress.com
My latest entries
TagsActive Operations Best Practices Big Data BIML C# catalog.executions catalog.stop_operation Clustered Columnstore Index Compression Data loading Data mapping Data modelling Data Warehouse DB Recovery Model ETL Execution_ID Fact Table Indexes Integration Services Catalogs Lookup Maxdop Minimally logged operations NoSQL Partition Function Partition Switch Partition Switching Partition Switch Out Performance POC Lessons Rebuild Index Rebuild Index Big Table Rebuild Partition Service Pack SQL Joins SQL Log SQL Parameters SQL Server SQL Server 2016 CTP SQL Server environment SQL Server Management Studio SQL Service SSIS SSIS.Catalog SSIS Package Paramater SSIS Project Paramater SSMS Custom Color SSMS Customisation SSMS Project sysobjects Trace Flag 610 TSQL Windows Server