Thanks Gail! I didn't realize it does all the checking prior to the actual inserts. I thought it did this after each insert. I learned something new...

Thanks all for your replies. I appreciate it!

My example didn't represent the whole story. I too agree that eliminating dups prior to the script would...

Did you ever find the solution to your problem? I have a colleague who can't see the Execute Task option when she right-clicks on a single task -...

Thanks so much for responding. You were right. Putting brackets around the table name took care of it! I'm still not sure how it worked in...

Thanks John! I will try that.

Hi MANU-J.

This is exactly the same thing I'm trying to accomplish. So if I'm understanding correctly what you're suggesting is to create another job that checks the date condition...

Thanks for your quick response!

I was struggling with knowing how to consecutively read Table A and update or insert it to Table B. The example they show without the merge, appears to me...

I think I finally got something to work. I would like to understand better why this works, but when spaces are True on my IF, then it handles the...

Yes thank you, I realized later that I need the false condition. I've been trying different things, but still getting an error when the field is blank on the...

Thanks for your response, but I'm not sure I'm following you. Are you talking about the "Data Flow Path Editor" between the flat file the derived column transformation step?...

Thanks JustMarie for being so thorough in your solution! It sure helped me out.

Ooops never mind! I should've looked at one more things before posting this. I found the "Data Flow" option under the SSIS/View in the tool bar.

Thanks for the ideas. I think you may have been on to something with the tempdb. All of a sudden without me changing anything, my script...

Thanks for your idea ALZDBA! I have never done anything like that before, but definitely something to consider. It sounds pretty slick. I will need...