Am pretty sure that you can't do this. The RDL got some serious extentions when moving 2008 (simple examples are the gauges etc, avail in 2k8 but not 2k5).

The...

Are you a local admin on your machine?

Can you screen shot SSMS as you try to connect the object browser to the SSAS instance?

What do you see, in the Services control panel applet? e.g. On my machine, I see the following

SQL Server Agent (MSSQLSERVER)

SQL Server Analysis Services (MSSQLSERVER)

SQL Server Browser

Obviously this is...

Using local host is unlikely to work when running a named instance. The fact that you can't connect using SSMS is concerning.

I hate to harp on it,...

Out of interest, is the key on your Month attribute something like 201001 for January 2010 and 200912 for December 2009? If the key is actually the same as...

To get around this I created views and casted the xml to varchar. I was 'lucky' though as I was able to use varchar(4000) because none of my xml...

Technically, yes, would you want to? probably not.

An old article on distributed queries, am sure there are newer ones out there --> http://support.microsoft.com/default.aspx/kb/218592

Is it a named instance?

Can/have you connected to it via SSMS? If so, what name do you use when connecting? Have you tried using this same...

And you do have SQL Server Analysis Services installed to the local server? Your service is either not started, or not installed.

Please don't cross-post.

All replies should be made at http://www.sqlservercentral.com/Forums/Topic860602-17-1.aspx

Not saying this is it, but have you used Expressions in SSIS? If not, it's *possible* that an expression is either i) changing the variable (assuming script is in...

Ok, am assuming a typo but are you *sure* the table is being recreated and it's not erroring out?

The DROP is dropping a different table :hehe:

Out of interest, the two queries you've provided reference different dimensionality for the rows, which may/may not make a difference (it could if the dimension is not related to the...

Done and done.

One thing to note - appears the XML Destination likes to consume strings rather than blobs. If you have some level of control over your OLE DB...

Hi Mick,

Seems to work as advertised. Ran a quick test with two XML files (XML Source in the dataflow) and then a single new FileConnection as the target for...