Neeraj Dwivedi (5/7/2013)

---

What I can see from your result that, once you get 'Trl' from Substring([Column 0], 4, 3), every thing else below that will be assigned Partitionid = 2....

Sergiy (5/7/2013)

---

You are missing column RowNo in your table Heap.

Files keep the data in physical order as they've been added to the file (because that's a definition of "file").

tables in...

Thanks All.

Dwain - Query works for me, but i don't think i understand what you mean by resolving multiple levels of hierarchy - my ignorance. I always have a predefined...

Thank you all for the feedback. I ended up using dwain.c's query. Other articles you provided are very clear too. There are a few problems i can easily solve using...

Exactly what i was looking for!

Thanks very much for the solution!!!

Thanks Phil!

It worked.

Thank you!

Convinced to store XML directly in a table.

A follow up question, let's say for example the XML file that's sent has 3 tags as below.

Always a blank field will...

Thank you both for the help! This is perfect.

Any ideas on how to write tsql do this please!

Thanks,

thanks much!

Perfect. Thankyou for the help!

RonKyle (11/16/2010)

---

You're lower levels would also have to be "hideable", or else it's not going to work. It looks like you have a level below city that would not...

Thanks Raunak! but can you be little bit specific, what do you mean by cube/browse properties...

Thanks all for your prompt response.... and Lutz, special thank you to you for those recommendations.

i totally agree with you...

That's correct it's an OLEDB connection. My all other config files have the similar connection string and works fine but not this package...

I am using a bunch of execute sql...