Hi thanks for the replies.

I was hoping to not have to create additional csv files, I was hoping to keep everything as simple as possible by having them open the...

Thankyou X100. It actually looks great in Report buildre, it shows all the columns on the same level so Im happy.

I had someone come accross last week saying that they...

*** usual its the key column. I had an attribute above funding LEA in the hierarchy which caused this to happen.

Its annoting because I wanted the data item above it...

Sorry its a fact table so the fact table links to the dimensions.

I think I have actually found NULL processing now within 2008 R2. I have changed the 0 values...

Hi there,

Ive managed to get it working but it took some going. I started small and worked my way up. It was indeed the keys

I just needed the key year...

Its WORKED!!!!!! :hehe::w00t::-D

Im going to do a few checks and then transfer to the real thing.

I canot thank you enough. Im going to update my help documentation with screenshots...

In fairness though the Microsoft guide is extremely none user friendly. I cant make heads nor tails of it. Also there are no great guides out there on how to...

SQL Statement EXEC dbo.usp_Test_Table_For_Parameters param1

param1

param1

param1

param1

param1

param1

to the table.

Brilliantly this keeps crashing when I try and add certain symbols. Ive readded the project as it stands because trying to add SQL Script into this hasnt gone well

Oh no....

I added Param1 to the SQL Statement and then checked the data written to the test table and this is what I have found.......

AC 06-07

Param1

Param1

Param1

Param1

Param1

Param1

Its taken the first parameter...

Thanks for your advice,

I dont want you to think I came straight on here to ask for help. I have done weeks of seaching on the internet and havent had...

Check that your ForEach Loop is configured to write the value(s) from each row into variable(s)

How do I check this?

…and that the variable(s) is mapped to the parameter(s) that you...

This is just a basic test for something that does need a for each loop.

I set it to ADO rather than ado.net but am not getting this as an error

Executing...

Absoloutely,

Im really wanting to get it sorted but Ive been put on anothe project with a scary deadline so Hopefully that will just be a temporary solution until I can...

Quick updaet,

I tried and tried but failed to get it working. I really didnt understand the script stuff onm the last post but I nearly got it sorted using ?...