Post reply

Write XML file using SSIS

  • November 2, 2014 at 11:25 pm

    #291633

    Hi

    I am working University Automation Project.In this purpose i got a student physical photo in folder and sub folder structure.Now my requirement is write all the folder path to xml file.I am new in SSIS. Please help me.

  • November 3, 2014 at 12:05 am

    #1756265

    vs.satheesh (11/2/2014)

    Hi

    I am working University Automation Project.In this purpose i got a student physical photo in folder and sub folder structure.Now my requirement is write all the folder path to xml file.I am new in SSIS. Please help me.

    So can we assume that you have a variable containing the path and want to write that out to a file like this?

    <?xml version="1.0" encoding="UTF-8"?>

    <FilePath>c:\Pics</FilePath>

  • November 3, 2014 at 6:29 am

    #1756310

    You're trying to use a flathead screw driver as a chisel.... not the right tool for the job. It's doable but there are other approaches much better suited. Powershell comes to mind, vbscript if you're so inclined.

    Steve.

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

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