Home Forums SQL Server 2005 SQL Server 2005 Integration Services Convert SQL data or Flat File or Csv File to XML ? RE: Convert SQL data or Flat File or Csv File to XML ?

  • March 23, 2015 at 1:48 pm

    #1785802

    Phil Parkin (5/3/2009)

    Have a look here for an example of how it can be done.

    http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx

    Blog is down :crying:

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001