Monthly Archives: January 2010

SSIS Dynamically Map Column Data Based on Column Pattern Profiling

SSIS Dynamically Map Column Data Based on Column Pattern Profiling Problem The problem set here is what to do when faced with an input file that has columns with multiple types of content(Domains). For instance a single column may contain … Continue reading

Posted in SSIS | Leave a comment

Master Data Services – SSIS MDM Load

    Master Data Services – SSIS MDM Load   Microsoft recently released Master Data Services in SQL Server 2008 R2 CTP. Without getting into the strategic benefits, definitions etc. of MDM(Master Data Management) this tool will be very helpful … Continue reading

Posted in Computers and Internet | Leave a comment