In an earlier blog post I demonstrated how to map between hierarchical (XML) and relational (SQL) … Running an MapForce mapping from SSISRead more
Month: August 2014
Using MapForce to insert hierarchical XML to relational tables
In an earlier blog post, I demonstrated a way to insert a hierarchical XML document into … Using MapForce to insert hierarchical XML to relational tablesRead more
Max or min value from a set of columns
The min and max aggregates in SQL Server are normally used to work over rows, getting … Max or min value from a set of columnsRead more