thx Phil, at the moment its all on my local pc.   i've been thinking about running it right on the sql server    1. under vs and 2) from the...

i tried loading just one column, the one with product in it.  and a constant string in the other column created in a derived column transform component.   removing most of...

• This reply was modified 1 year, 3 months ago by stan. Reason: same 1000 record mistake

i thought the pkg was dying on record 1000 but that isnt true.   i'll recalibrate.   at the moment it looks like i have about 12000 + records perhaps from one...

• This reply was modified 1 year, 3 months ago by stan. Reason: mistakenly thought it was going down on 1000 records. have to recalibrate

thx ant-green and frederico_fonseca.   the good news is that we are now getting notified when the job completes.

thx jeff.  that's (code or data generated) too proprietary to post here.  and/or too expensive to obfuscate.

what did you think you would see?  I already asked my peers if there...

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

for some reason a duplicate reply was posted here after i got an error on the first reply.  sorry.

• This reply was modified 1 year, 4 months ago by stan. Reason: duplicate reply after forum threw an error on first reply

i do see this in the definition script but have to wonder how sql associates these names with emails.  Am i going to be typing "and my name"?   How will...

this article seems to talk about that "view".   i'll have to poke around looking for step/job completion status, limitations , latency etc while job is running etc.  i'm a bit...

thx Phil and Steve.

Phil I wouldnt want to do that to the community since i know how to use the stuff command and xml path.  I was being a bit...

didnt know.  so answer #2,  kind of piling on answer #1 is that the users who pivot would need minimally a pbi pro license.   i dont think we want to...

appreciate the support phil.   if anyone out there ends up in my shoes it sounds like the "Suite Scripts" team is the one you want for guidance.  I chose accounting...

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

thx Brian and Phil.   If Netsuite's invoice etc API's can do this,  i would prefer to go that way.    I show a snippet below of their api list etc. ...

loaded question but i'll try.  for starters we plumb more than just pbi to cubes.  for example excel pivots.   i understand there is an extension to excel called power pivot...

not yet phil.   will look at it soon.

thx Perry and Phil.   Perry i'm not sure why you say vdi is better.  Phil, i dont see semantic models and ssas necessarily as alternatives.  i see them more as...