when i did that i got junk characters there . can u pls advise

I tried both of them, you know the problem is the result is displaying for only one record. Can you tell me how to post my output as you have...

Initially the data is like the first image. I used the above query and made the data like in the second image. Can you advice me how to change my...

Sorry i am new to it . I post it according to the link you have shared ASAP

How is that it is taking in SSMS only 9 secs. And when i place the same query in the SSIS it is taking more time to pull the data...

Yes, the query takes only 0.9 sec. But when i run it in the package for pulling the data it is taking more than 20 min . Please advice me