Home Forums Programming XML convert CSV file to XML file format based on XSD file using SSIS (SQL Server 2008R2) RE: convert CSV file to XML file format based on XSD file using SSIS (SQL Server 2008R2)

  • August 2, 2011 at 4:03 pm

    #1362739

    krish.sett (8/2/2011)

    Thanks for your suggestion ,however our team is looking for something Open source.let me know if we have something like XML Spy which is open source.

    I have the XSD file for my XML file ,Can we convert using some .net plug in ?

    XML Spy is just a development tool. SSIS, which you said you were open to using, will do the actual conversion of your CSV file to an XML file using the XSLT file you designed in XML Spy and the XSD you were given. Have a look at the XML Task in SSIS. You would be looking at a config similar to this:

    If XML Spy is too pricey search for "free xslt designer" or "open source xml ide" and see what turns up.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato