SSIS XML Destination

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » SSIS XML Destination

SSIS XML Destination

Rate Topic

Display Mode

Topic Options

Author

Message

farooq.hbs

Posted Sunday, January 06, 2013 11:19 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, March 18, 2013 1:44 AM
Points: 99, Visits: 160

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

sumit.joshij

Posted Monday, January 07, 2013 12:18 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:06 AM
Points: 47, Visits: 266

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

farooq.hbs

Posted Monday, January 07, 2013 2:19 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, March 18, 2013 1:44 AM
Points: 99, Visits: 160

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

sumit.joshij

Posted Monday, January 07, 2013 2:23 AM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 6:06 AM
Points: 47, Visits: 266

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 »

Permissions