Many thanks,

I have been playing with this for a little this morning and have changed it so that if [Measures].[R] = 0 THEN [Measures].[R]

Not happy with that but...

Should say I know this can be filtered out when querying but I want it to be right in the cube in the first place.

Thanks

E

Yes,

on my searches through I did come across this as best practice and I will be looking at this as an enhancement. Was more focused on the lookup.

So that's...

Have added the resolution here.

Many Thanks

E

:w00t:

The solution I have gone for (thanks to Koen) is to use a lookup transformation and to have an expression on there that will dynamically limit the number of rows...

Thanks guys,

Will look at. The expresssion on the lookup. Previously I have resorted to insert and update statements. I gained performance and control and error trapping.

Scott,

I gave used CDC before...

I am inclined to surrender and go for the lookup. Perhaps what I wanted is not so easy. I just thought it would be nice to do the lookup against...

From what I have read Partial cache may not be a good option. I am considering Merge Join which will make the inserts and updates on the limited set of...

Yes and yet No,

I was hoping for different solutions from different people

For the SSIS peeps:

Would a lookup task be perfomant on that size data set. I am not sure of...

after a lot of effort this was resolved. Not quite sure which change did the trick but yes it was NTFS permissions based issue.

Quite a learning experience.

Thanks

😀

Having looked at another project I have created the bin folder and development subfolder both appear to have the same settings?

The only thing I can think about is the project...

The individual dtsx file is not showing as read only.

I can create or save a package as with a different name.

I cant run them from the designer now. It pops...

The Bin and Obj folders I just cant change that away from a greyed tick in the read only?

E

On the folder that contains the project it comes up with a grey tick in the read only so I know some files \ folders undernmeath are read only.

So the...

Still looking into this. SSA jobs will be set up under a different account and one that will not be discontiinued.

Still unsure on the database owner and may go SA

Thnaks...