I agree, I have seen this happen in SSAS before when the sum of the value is larger than the data type the number turns negative.

they will the same (or very similar) at the end...

you need a minimum of 1GB. pratically you need at least 4GB.

http://msdn.microsoft.com/en-us/library/ms143506.aspx

We really need more information to be able to provide any advice, since we do not know anything about your system and the application that is causing the issue.

Yes it is possible in SSIS, with a script task you can pretty much do anything.

you can use the Http connection manager with a script task,

or else use the...

it depends on your source data, if you have an icremental key or datestamp then it should fairly simple.

you cant run CHECK DB on TempDB,

It is not needed as it will be recreated when the server starts.

another way of doing this is to;

1. right-click on database and click process.

2. select script

3. copy this script

4. use this scripts as a task job of type SSAS command.

mw112009 (9/27/2011)

---

Reply to Craig:

Ok, hers is what I am saying: I ran the following SQl in the SQL server management studio:

select [definition] AS ProcDef, LEN([definition]) as 'len'

from

...

rothj (9/27/2011)

---

Very sorry I did not include that. My bad.

Sorry to waste your time. I initially just thought I had the format incorrect.

How do I get around this?...

rothj (9/27/2011)

---

OK, we have the format correct.

I think the problem is 2012 is a leap year.

It is failing on February...specifically the 2013-02-29 date.

The language is us_english and dateformat is mdy....

Yes absolutely , if you have the resources then this is the only sure-fire way of ensuring you have 100% clean backups.

I agree with RonKyle Unkown members should be handled before they they get to the cube in the ETL process by creating an unkown member and assigning this...

To be honest, its going to be...

I would go for the upgrade only because some of the feature look so good.

and the first release should be stable, and they are alreay on 2005.

though i guess it...