Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services Services

Question

Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services Services

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

skendrick SSC Enthusiast Points: 132 More actions · Answer 1

I finally got it to work. I was having issue with the data type and also the order of the parameters selected had to match what I was having modified into the database.

Thanks again for the wonderful guide lines.

nishantd Valued Member Points: 63 More actions · Answer 2

Hi Everyone,

I am a beginner in SSIS and was following the tutorial to learn and got stuck at one step.

In the Advanced Editor for OLEDB Command while column mapping, there are no columns like param_0,1,2,3.

Don't know what I did wrong. Can someone help me.

-Nishant

thomland SSC Enthusiast Points: 150 More actions · Answer 3

Hey guys,

can you give me any hint how to implement the delete function in the same dataflow?

Thanks in advance!

Kinde regards Tom

jetboy2k Mr or Mrs. 500 Points: 529 More actions · Answer 4

DOH!! Never mind...

If the MiddleName is NULL in both records, it hasn't changed, and we don't need to update that record.

Again...DOH!!

I'm unclear about how the Isnull formula applies in the following expression:

FirstName != LkUp_FirstName) || ((ISNULL(MiddleName) ? “Humperdinck” : MiddleName) != (ISNULL(LkUp_MiddleName) ? “Humperdinck” : LkUp_MiddleName)) || (LastName != LkUp_LastName)

I understand the need to "capture" NULLs, but in looking at the above expression, I'm thinking in terms of a record where the middle name is NULL in both the source and destination tables. In this case, I would think that the following results would be generated for the MiddleName ad LkUp_MiddleName values where the Middle Name is in fact Null in both tables:

(ISNULL(MiddleName) ? “Humperdinck” : MiddleName) => “Humperdinck”

(ISNULL(LkUp_MiddleName) ? “Humperdinck” : LkUp_MiddleName) => “Humperdinck”

And if that's correct, then the result of the comparison operator would be:

“Humperdinck” != “Humperdinck” => FALSE

So, assuming that FirstName and LastName have not been updated, you would get FALSE for all three comparisons, which would of course be a FALSE for the final condition result, and the Lookup Match Output would not include this row, since there are no matches.

That said, it's obvious from the following image that the comparison does work, so can you help me understand what I'm missing?

Thanks.

Make an Impact SSChasing Mays Points: 652 More actions · Answer 5

After looking at this topic I remembered my initial days of MSBI career (~ 8 yrs ago) where I have got a task to handle incremental loads. Such a detailed explanation doesn't only solve the problem but it builds confidence in both developer and his ability in tool. Thanks a ton Andy!