PostgreSQL - Update and Delete Destination Problem
Posted: Wed 24 Jun 2020 14:13
Hello, Devart Team!
I’m using the SSIS Data Flow Component for PostgreSQL, and I’m having a problem with Update and Delete functions. When the Destination Component can’t find the register’s Primary Key, it evaluates to the Success Output. However, if the register’s Primary Key was not found to do the operation, it needs to do to the Failure Output, because the operation (Update or Delete) haven’t been made at the destination, and I need to count how many times this situation have happened. I need your help to solve this problem, please.
Thanks in advance!
Cleiton.
I’m using the SSIS Data Flow Component for PostgreSQL, and I’m having a problem with Update and Delete functions. When the Destination Component can’t find the register’s Primary Key, it evaluates to the Success Output. However, if the register’s Primary Key was not found to do the operation, it needs to do to the Failure Output, because the operation (Update or Delete) haven’t been made at the destination, and I need to count how many times this situation have happened. I need your help to solve this problem, please.
Thanks in advance!
Cleiton.