Thats a good idea, but when i was writing the code noticed that the SSIS package connection was for the database in question, not the Master database! changed the SQL...

Hi Tahnks for the update,

I've tested the proc with single user mode and the offline mode, and nope it doesn;t work on the restore part

thanks

Jon

Hi Steve,

thanks for the link, i did come across it before. I've had a look at the book on google books, its seems to be the method i'm going to...

Hi Steve,

thanks for the info thats very helpful, i'll have a go at breaking out the measures from one column into a few, see where i go from there

thanks

Jon

Hi Ells,

WeekDesc1 etc are just versions of how we describe the week. WK1, P1 WK1, 1, W1 etc.

Its the FullYear MemberCode that has been renamed as MemberCode in the...