thx ed are you talking about these?   so every source to dest occurrence in the dft shares in this total or has its own pair of these same limits.   i...

i ran the pkg from csv to sql on the sql server itself in 25 SECONDS.     Not sure what to conclude from this but i'm tempted to open a...

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

i ran the pkg sql to sql.   it ran in less than 5 seconds.   because i have a derived column component between the sql frokm and to adapters, i believe...

-update...i ran the pkg with a csv file as an ssis  flat file connector.  and it took just as long, approx 30 minutes.   all i can conclude from this is...

i should have mentioned that the multiple runs today were over vpn from my home.   whereas yesterday all the failing was inside the firewall at work, ie on prem internally. ...

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, 1 month 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, 1 month 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, 2 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, 2 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...