Post reply

SSIS XML Destination

  • January 6, 2013 at 11:19 pm

    #393879

    Hi guys,

    Using SSIS pacakge i want to get the XML format dataset output from the OLEDB soure data

    Is it possible? If it is then which control items/ Data flow component will work on this

  • January 7, 2013 at 12:18 am

    #1574183

    There is no XML Destination.

    Workaround:

    1) You have to convert you query in XML format like "FOR XML AUTO" or "FOR XML PATH"

    and 2) then choose the destination in "flat file destination" and 3) put the name like as : "xyz.xml".

    Thanks

    Sumit

  • January 7, 2013 at 2:19 am

    #1574212

    Thanks for the reply.

    I did the same to get the result.

    I tried using Execute SQL TAsk and Script Task

    The output is

    <EMPID>1</EMPID><EMPFName>Karthik</EMPFName><EMPLName>Anbu</EMPLName>

    But i want the output similar to the below sample

    <BrokerData EMPID="547645" EMPFName = "Karthik" DELIMETER="#" />

  • January 7, 2013 at 2:23 am

    #1574214

    Then you have the attribute in it.

    Check http://msdn.microsoft.com/en-us/library/ms345137(v=sql.90).aspx link for your reference.

    Thanks

    Sumit Joshi(sumit.joshij@gmail.com)

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

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