April 25, 2012 at 11:48 am
I have about 6 mil rows in my data flow, and a derived column component right before sending rows to staging. The DC bats cleanup, replacing Null keys with -1 (our unknown member) as we do not allow nulls (ClientKey for example).
This is not a new component, it has been in place in this package for quite a while. It has never changed the number the rows before, just this time. And it stole about 500k rows, so not a trivial issue.
My error output is Fail Component for error or truncation for all 5 instances.
Not sure if this is related, but we have been experiencing some serious network latency, so this package took 3 times as long as it normally does. this is from VS environment.
April 25, 2012 at 11:49 am
uh, even odder - the correct number of rows went to staging, the wrong number of records is shown in the flow.
Please ignore post, it's a non-issue (aside from untrustable flow numbers)...
April 27, 2012 at 6:03 am
herladygeekedness (4/25/2012)
uh, even odder - the correct number of rows went to staging, the wrong number of records is shown in the flow.Please ignore post, it's a non-issue (aside from untrustable flow numbers)...
Never never trust the BIDS designer. Ever. 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
April 30, 2012 at 8:51 am
Yeah, so I'm coming to find out!!! S'ok, knowledge of shortcomings and Known Funks is good...
I had just never seen the data flow numbers be SO OFF. Given that I have a deduping script higher in the flow, bossman grew gray hair right before my eyes as he figured my deduper must have gone on a rampage...
no, look, it got down to exact right number we need from my script, something else got hungry!
April 30, 2012 at 9:17 am
A Rampaging Deduper - who said IT can't be exciting?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply