I have a dataflow that read a table.(row : "id_agency","id_society","name_society","name_agency", "turnover") There is a conditional split where if i have a "id_agency" or "id_society" at blank , i load this wrong data (and so all the line data) in a table called Refusal.
But after load all this "wrong line", i want to generate a raise error and so stop the ETL flow but i don't know how i could manage that. In the control data we can use a sql task et write a script with raise error but how i can manage to do that in a data flow and after have loaded a table ( refusal table).
Thanks in advance for any help and excuse me for my english mistake.
regardless,
But after load all this "wrong line", i want to generate a raise error and so stop the ETL flow but i don't know how i could manage that. In the control data we can use a sql task et write a script with raise error but how i can manage to do that in a data flow and after have loaded a table ( refusal table).
Thanks in advance for any help and excuse me for my english mistake.
regardless,