you can script it.

Go to your source AS server, go to the needed dimension, right click "Script dimension as..."

Choose create if it doesn't exist on other server, choose...

Have you tried to set the Access destination to Ignore Errors or redirect? I'd be curious if some funky value is attempting to be written but can't, yet SSIS...

to clarify further: NO ONE, and NOTHING but your package accesses Staging. it is your "work table", that is its sole purpose, to serve your data flow.

Oh good, it sounds like you get to travel a better path!! Please post back on how it goes.

We're a small company, we don't do incremental loads after the prototype for that was waaaaaay too long-running to be a daily deal (8-10 hours on a good day). ...

nice!!! seems a bit like the old shell game and I admire the simple bit of trickery. Wish I would have come up with it!

I'm very surprised to find out that SQL Azure doesn't support SSIS!!!

What "on prem" are you talking about? Seems to be a highly relevant detail that we are missing,...

I'd keep it out of their hands to start with!

is there a reason why the users have it vs a scheduled job?

That's teh thing - the server seems to barely notice that anything is running!!!

I decided to remove the sort from right after the main source query to see...

I would urge you to look around the SSRS forum here as well. I have not used Word in any BI project thus far.

I don't understand why project status...

I generally have an Execute SQL task that goes to my staging table to be sure there are at least a certain number of records. Evaluating @@RowCount gives you...

yes, cleaner. Staging for me is simply a table of "this run" that will either become the new fact table or fails for whatever reason. Not a separate...

+ 1 for Staging.

Yeah, so I'm coming to find out!!! S'ok, knowledge of shortcomings and Known Funks is good...

I had just never seen the data flow numbers be SO...

It does vary. In control flow, I can execute one task at a time. I cannot do that in Data Flow. I can execute the entire data...