Post reply

Importing xml file from data profiling task into SQL Server Tables

  • July 2, 2015 at 12:28 pm

    #305538

    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

  • 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)

  • July 8, 2015 at 11:19 am

    #1811063

    Thank you,

    I was able to use the xml out put as a source to pull into SQL Server tables.

    Regards,

    Jonathan

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

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