Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS XML Destination Expand / Collapse
Author
Message
Posted Sunday, January 06, 2013 11:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:30 AM
Points: 104, Visits: 173

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
Post #1403415
Posted Monday, January 07, 2013 12:18 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:49 AM
Points: 48, Visits: 269
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
Post #1403435
Posted Monday, January 07, 2013 2:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, April 03, 2014 8:30 AM
Points: 104, Visits: 173
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="#" />
Post #1403489
Posted Monday, January 07, 2013 2:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 11:49 AM
Points: 48, Visits: 269
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)
Post #1403491
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse