locked
Web Service to XML to Excel Issue RRS feed

  • Question

  • Hi,
    My problem is somthing different. My workflow is not working.
    - I'm using a webservice... which populates an XML file. For this I've created a "Web Service Task" in Control Flow.
    - Then in "Data Flow Task" I'm using this XML to export it to an excel file. SO I've created an "XML Source" and "Excel Destination".
    - From the XML I created the XSD... and i also created an excel file with the column names according to the XML Source window.

    When i run the workflow... it shows everything green and no errors... but it does not show any record in excel file.

    Please help :(

    -Manoj
    Tuesday, August 25, 2009 3:03 PM

Answers

  • Manoj,

    In BIDS add a Data Viewer in your data flow.

    STEPS: 
    1) Right-click on the constraint/line between the XML source and the Excel destination and click on "Data Viewers...".
    2) Click "Add" button to bring up the "Configure Data Viewer" dialog.
    3) Select the type "Grid".
    4) Click the "Grid" tab and select columns of interest.
    5) Click the "OK" button.

    Now run your package in BIDS to see if your data flow is finding any rows in the XML source.  Let us know okay!

    Cheers,
    Patrik


    This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, August 25, 2009 5:59 PM