Hello, I have abig problem in updating an existing record. my target database is oracle and the source table is a Text File. I successfully added new records by using Insert query in DB Output component, but when I try to update and existing record, an error occurs. Is there’s a way for me to update the existing record in the target database? I already tried removing the datas from the target but the problem is, those datas have constraints, so it will not allow me to delete existing data. Please healp me… Thank You…
It’s working now… 
Thanx…
Now i need to work on my LookUp Errors.
Hello,
did you try use DBOutputTable in this way?
OtaSanek