Cheers guys,

So far the wiseowl 3 day course http://www.wiseowl.co.uk/courses/ssas-cube-analysis-services.htm appears the most likely candidate.

When looking at the M6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services course...

OK Here's how I did it should anyone else need to know.

Forget dataflows...

I used a script task into which I fed the sml filepath via a variable and read the...

There must be a way to do this, i've just re-read my post and it sounds ridiculously simple!

How do i get xml from an xml file into an xml field...

You could use a derived column transform after your excel datasource task.

Use substring functions inside the derived column task to split the fields using nth occurences of the literal spaces...

Hi,

The age old problem...

Within the event handler environment a number of extra variables are made available. Some of these are to do with errors...

You could possibly (i've never done it)....

*...

SOLVED!

OLE DB DESTINATION > Advanced Editor > Component Properties > Fast Load Keep Nulls > Set to True

This will allow fields in the destination table to keep defaults when a...

Package configurations are a good option as you can read from table as well as XML files.

An alternative method (not neccessarily the correct method but it works) is to do...

Great article, i've stretched the copy and restore delays as far as i can within the sync limit though our log size surges seem fairly random so I can't schedule...