thx all, i'm going to try to digest all of this.   And post back here.  This post has already opened my eyes to a possible benefit of api's in that...

• This reply was modified 9 hours, 31 minutes ago by stan.
• This reply was modified 9 hours, 30 minutes ago by stan.

thx phil, how did you learn anything then without breakpoints working?  msgboxes?

thx phil, are direct worse?

i think we get it frederico. thx.

 i think you are saying the source is a .bak.  and then various etl tools can  be used to copy that to a local...

i wonder if making that table a temp would get us past any permissions issues we'd have otherwise.     now that i look at it closer i dont understand.   how...

• This reply was modified 3 weeks, 3 days ago by stan.
• This reply was modified 3 weeks, 3 days ago by stan.

thx carwalk.   The "servers" are one in the same.   From our dba's solution it should be obvious with hindsight that  ssas can reach the engine.  We've tried and already documented...

i'm going to draw a picture for our new bosses.   I know one objection will be "too many levels".

The visual will basically represent this    BI Org (org level)->Netsuite Migrations...

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

i got word from our network guys that their patches are OS level only.   If i could make a living going down rabbit holes i'd travel this one because the...

thx steve, we should know soon.   The remaining errors are manageable/migration ones that we know how to deal with.   i will post results back here as soon as i get...

wow, our dba spent all morning on this.   he changed 1) the provider from the native sqlclni11.1 to msoledb...   2) he added a comma and port # to the conn...

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

our dba got back from pto.   He asked me to delete all 3 of the ssas db's there, recreate one and set trust cert to true on the connection's ALL...

i've asked the folks who set this up if we can move "BI Team" to a higher level (maybe there is an ORG or OWNER?) and use Project (the what...

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

it took a minute for the light to go on but the word Feature sounds more like a releasable than the word story.  That bums me out a little.  my...

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