Every business intelligence solution needs data, which might come from a variety of sources and in different formats. Microsoft SQL Server Integration Services, or SSIS, allows you to extract data ...

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 ...

Using SSIS's graphical designer, the task is straightforward, if not entirely intuitive. Create an Integration Project with a Data Flow Task Create a new project. From within Visual Studio 2008 ...