BR><BR>The simple method would appear to be using SQL Server's SSIS Data Flow Task with XML as a source [edit: more specifically, using the XML Task]. However, the XML in question is backed by 8MB ...

When building an SSIS package ... Let's look at an example. Fig. 1 shows a simple data flow that loads data from a flat file, called NewStores.txt, to a table in SQL Server called Stores_Staging.

BlueFinity International recently demonstrated how to create a simple SSIS transformation to move MultiValue data into MS SQL Server using mv.SSIS in a free webinar on March 1. According to BlueFinity ...