thanks Phil.   I couldnt see how to author the sequence command along with the refresh format i showed in the original post.   I think MS is telling us that only...

my thought was that a "thread" would lessen the chance of a memory error.   And that that was one of the tricks out there for getting around some memory issues. ...

• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.

thanks, does anybody have access to enterprise?   The reason i ask is that there was a time when you had to use a backdoor thru multidimensional   to achieve this form...

• This reply was modified 1 year, 8 months ago by stan.

thx Eirikur,

throttling in this context means he gets some relatively lower priority if we go with a "live experience".  That (live experience) should have been clear from the original post. ...

thx frederico.  we are doing a process full at the moment.  going to read your link which probably contains the guidance phil was giving also.  it would have been so...

• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.
• This reply was modified 1 year, 8 months ago by stan.

thx Jeff for your time.   Unfortunately the reports needing the data are operational.   So the data they need is pretty detailed.   So the volume is going to be a factor...

• This reply was modified 1 year, 8 months ago by stan.

thx phil

thx Jeff, you are basically suggesting ETL loading data incrementally after reshaping into a star.   we actually talked about that but arent ready.  we do it in other business areas...

ssrs but i think we got it figured out.  thx

yes, now i can.   appreciated.  will try running one of (there's only one right now anyway) the pkgs from sql agent shortly.

thx Emperor100.  2022 under project->...properties->config->general .

i think i got it.  The path is /ssisdb/folder name/project name.       And in order to make everything fluid, you have to hit "connect" in the wizard next to...

apparently you right click the top left data cell, click insert and choose subreport.  Its pretty self explanatory from there .  In the dataset you bind to the tablix, one...

he wont have permissions but i think i'm liking your local host idea.  I have to check how big that db is.

Thx Brian.   He wont be updating.   I appreciate your response.   A sandbox is my next choice but i want to go down this path first.