Post reply

Loading CSV file as XML file into SQL Server

  • October 24, 2010 at 5:02 pm

    #143200

    hello,

    I have data in CSV files and I wanted to load these data into SQL server as XML files.

    Can any one please help me in this regard like which components should be used and how to configure them and if there we need write any code for this package etc.

    thanks in advance

    thanks

    Sasi.

  • October 25, 2010 at 11:58 am

    #1241791

    I'm clear what you want to do. Do you want to combine all of the csv columns into an xml datatype and load it into one column?

    Russel Loski, MCSE Business Intelligence, Data Platform

  • October 25, 2010 at 12:09 pm

    #1241799

    hello,

    thanks for responding and yes I want to make a CSV file columns into XML file column and after transforming how to load it into new table?

    thanks in advance

    thanks

    Sasi.

Viewing 3 posts - 1 through 2 (of 2 total)

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