SSIS XML Destination

  • 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

  • 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

  • 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="#" />

  • 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