Home Forums SQL Server 2014 Development - SQL Server 2014 Importing xml file from data profiling task into SQL Server Tables RE: Importing xml file from data profiling task into SQL Server Tables

  • July 2, 2015 at 2:26 pm

    #1810062

    Jonathan Marshall (7/2/2015)

    I just used the SSIS data profiling task and exported data into an xml file.

    How does once get that data that has been exported into an xml file into database table(s)?

    Regards,

    Jonathan

    How about an XML data type column? You might be able to go directly into a table with such a column via SSIS.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)