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