Post reply

convert CSV file to XML file format based on XSD file using SSIS (SQL Server 2008R2)

  • August 2, 2011 at 12:21 pm

    #254800

    Hi All,

    In my current project we have requirement where i have to convert CSV file to XML file format based on XSD file using SSIS & T-sql .

    Could you please let me know the best way of converting CSV to XML file format...

    Thanks for your help

    Regards

    Krish

  • August 2, 2011 at 12:25 pm

    #1362478

    Why does it have to be SSIS?

    in t-sql we can use the "FOR XML" option which converts the whole table for you.

    SELECT * FROM sys.tables FOR XML AUTO

  • August 2, 2011 at 1:10 pm

    #1362531

    Hi,

    Thanks for your response ,I know we can do it in T-SQL, however my output needs to be XML.

    So I dont see any need to populate CSV data to a table before converting into XML.

    Is there any better way instead of storing into table and then converting into XML.

    Thanks

    Krishna

  • August 2, 2011 at 1:19 pm

    #1362542

    Well I gave you the output you wanted in XML.

    I don't know any other way of doing this so I'll step aside.

    Good luck with this.

  • August 2, 2011 at 1:19 pm

    #1362543

    P.S.

    How big is the csv file?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply