2 challenges so far.    I'll post my progress here.  I'm using vs2022.

if i use the more generic approach shown by AI in my first image (posted separately) , i...

setting the protection level to "dont save" didnt at least allow me to "test the connection".   nor did following that up with the "passive" check box.   i'm moving on to...

thx lisa and steve.   simply reducing the number of rabbit holes like you guys have done is invaluable.

before i go the code route, i may try toggling one of those...

• This reply was modified 8 months, 2 weeks ago by stan.

thx steve, yes i always go to advanced with things like this.  in this case, in the final oledb destination, i change the data type in advanced and ssis ignores...

• This reply was modified 9 months, 1 weeks ago by stan.

this gets better and better.   we see the same values on another vm's config  where there is no issue with processing full an ssas db.   we also see the problematic...

i believe this is the problem.   Does the community know what causes these values to be set to 1?   Is that perhaps the default nowadays?   I dont see them even...

• This reply was modified 9 months, 1 weeks ago by stan.