vendredi 4 novembre 2016

Design pattern recommendation for the below mentioned ssis data flow

we need to refresh a table from the csv file.The source file columns are of text type.instead of using a derived column to convert the data type we use flat file source editor to change the data type as per the target.

The idea is to avoid un necessary processing by derived column. if there are errors in flat file data reading then we divert it via flow2 Is this a good ETL design pattern!?

enter image description here

Aucun commentaire:

Enregistrer un commentaire