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