which one to use conditional split or data conversion or both transformation

Question

My source file contains some bad data. I want to load the correct records in table A and error records in table B using conditional split or data conversion or both transformation

Answer 1

Hi @San ,

1. If we just want to split the data into different tables, we can use Conditional Split Transformation.
   
   
2. If we want to get the bad data, we can use error flow redirection.
   
   

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues in November--What can I do if my transaction log is full?
Hot issues in November--How to convert Profiler trace into a SQL Server table?