Check to see if a record exists

For a good discussion on checking to see if a record exists or not in SSIS (and if it does, update it else insert it), please head to the following link:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1211340&SiteID=1