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 you start working with SQL Server and SSIS, it won't be long ... There is one last step to use the query you built. Open your source in the Date Flow, set the Data Access Mode to SQL Command ...

Execute SQL tasks run stored procedures or SQL queries from SSIS packages ... as well as to prepare and truncate data and to return result sets. You can also combine tasks with iterative code ...

Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services ... the data flow task icon and ...

When building an SSIS package ... 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. Fig. 2. shows the mapping ...