Found the answer from other posts.

First, change the TargetServerVersion property for the project to the version of SQL Server you are using for SSIS as explained by the links below...

My post was just an example to narrow done the issue. I'm really connecting to an Oracle Database and got the same error. Anyway, I figured out the answer and...

Does any one have any ideas? Some more information... If we use the Oracle Attunity driver, we are able to directly connect to the schema and it works as expected....

Not that I am aware of. This was setup originally choosing the default settings. Is there a way to turn that off or to fix it somehow that you know...

I solved it. It ended up being that the server being referenced in the job step that was calling the SSAS command was still pointing to the old server.

Thanks everyone for your responses. What I'm getting from this is that by adding more simultaneous processes, it's putting pressure on the RAM and likely processing some items on disk....

It was a very strange and messy setup so not surprised best practices were not followed.  Anyway, to clarify...
When you say you're suprised "the 2018/2019 years could be entered"....

More information.... I think that my SQL Developer is a 32-bit installation.  I noticed that the instance was installed in my "C:\Program Files (x86)" directory which is the location for...

That was it! Thank you. Geesh... so obvious =D
Wow, as much as I know about Excel... that just eluded me somehow.
Thanks again for your help

Here's a picture of what it looks like.  You can see where it says "2014 Actual" and "2015 Budget". In the field list, but the underlying database all labels say...

Ok. I think I see what you are saying now.

Correct me if I'm wrong... you're saying that the error is being generated from the IF clause portion of the...

Thanks for the suggestion. This is actually something developed by someone else, but thanks just the same. However, this isn't what is causing my original problem. Any ideas...

Thanks for the response. Tried to add the style and it is still giving me the same answer.

Um. Only because I didn't know you could =) Thanks. That seemed to work. Also saw you could deploy to another server as well from Visual Studio.

Thanks!