I have one question about this section:

Enter the credential name - Enter the domain account, and password. Repeat the password in the 'Confirm password'. This account should have the...

I describe how to make a Lookup do a Left Outer join around Figure 6 in the article. I repeat this process for Right Outer joins, I simply swap the...

Ken,

Did you do the programmed lookup in SSIS 2005 version? Let me briefly introduce my case here. Against Andy's article, I use a Flat file source to read a collection...

Andy,

You might midunderstand my question. What I mentioned in above post is what if the lookup transformation looks up a Flat file as destination instead of a normal table(The source...

Thanks, Andy. What you mean is to build anothe data flow task, drag an OLEDB source in it to take the destination table(In your example New_Rows OLEDB Destination) as source...

Hi Andy,

This is to continue previous discussion I post above. I followed all your article and got the same result(new and update) as you showed. for trying deleted rows case,...

Hi Andy,

I'm trying to put a a case of delete rows to data flow task in your example. I searched your previous replies on this issue, you said use right...

Hi Andy,

Thanks for replying so quickly. From my understanding of reading your reply, just write(insert) the detected changed rows to a stage table(in your example, it be "Changed Row" OLEDB...

Andy,

In your article write changed rows, "To do a set-based update we first stage all the data we need in a stage table. When we’re done with our Data Flow...