Thanks a lot for your reply!

Getting error at "dbo.DelimitedSplit8K" and may i know what is Item in your query. I am new to these concepts.

Can you please eloborate...

Thanks!

Kumar

Thank you very much rVadim!

your query working pretty good.. but mispairing in A and B. Sorry I did'nt provided that info..

TextA should be pair with TextB which comes next to...

i need something like.

File Main A B

917 ...

Here is the scenario please..

For exmaple if i have the fields like below

File Main ...

No. all fields will not repeat as same. Text may be same but File and Main will be different..

thanks for the Reply!

If i use Aggregate functions then its eating some of my data fileds. For MAX its giving only maximim valuse of available filds..

Yes, I have only two group of values "A" and "B" need to be pivoted

Here it is:

<?xml version="1.0" encoding="ISO-8859-1" ?>

- <!-- ArborText, Inc., 1988-2001, v.4002

-->

- <doc>

- <topics>

<topic id="T87478">text</topic>

<topic id="T12642">text</topic>

<topic id="T82199">text</topic>

...

Thank you all for reply!

thing is that i dont have Bulk Insert permissions. Can we do it by writing C# code using Script task in SSIS?

Kumar