Microsoft SQL Server Integration Services, or SSIS, allows you to extract data from databases, including MySQL, load the data into a Microsoft SQL Server database and transform the data into a ...

I am working on a project that requires moving data from a large un-normalized ... Is this something SSIS can do easily? I know it can transform fields and all that but I've not seen any examples ...

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