Hi Alistair

Just the first part - getting the data into another table. I can port through to Crystal.

That field has many potential values.

Cheers

Mat

Hi Alistair

Just the first part - getting the data into another table. I can port through to Crystal.

That field has many potential values.

Cheers

Mat

Hi thanks Alistair

Only problem is it comes from a table with around 10,000 entries. The table name is called Component Assessments. All these entries have to be extracted and re-formatted...

Sure, thanks

PropRef (unique property reference), is the primary key (INT, 6).

AttributeName, is the attribute name (VARCHAR, 50)

AttributeValue, is the value for the attribute (VARCHAR, 50)

Propref ...

Hi John and thanks for your comments.

I will have a look at the shredding option as you suggest.

On the XML Source method. I can now see what you mean. The...

Thanks again Phil and for the record to way to pick-up multiple files for importing is to use the Data Flow Task under the Control Flow tab. You place the...

Thanks Phil.

I'll give it a shot.

Mat

Hi Phil

Thanks for the reply.

I don't currently have a Foreach loop. This sounds like and good idea (sorry I very new to this product). What do you think might be...