There were few scenarios in which we had part of our data being published to Cloud DB (Microsoft Azure DB) for external access. One of the main requirements was to keep both databases synchronized There are couple of ways by which you can…
Fuzzy lookup issues in 32 bit runtime
This post is regarding an issue I found while working with SSIS 2005/2008 fuzzy lookup using 32 bit runtime on a 64 bit instance.Recently I was using fuzzy lookup in SSIS package data flow as a part of my requirement in…
Shred data as well as metadata from XML document
Quite often I’ve come across requirements where we’ve the data coming in XML nodes and requiring us to create a table using them. The below code gives us a method to shred the data from XML document. The code shreds…