Planning to import 1000s of text file to sql server tables. All these files are having different structures and it goes to corresponding new tables in SQl. Different methods coming in mind is using of Biml /creating ssis packages with number of data flows/using import wizard.
What is the ssis design pattern to achieve this in most time efficient way. This is a onetime load though.
How to handle the failure ? : I am not considering the checkpoint because ,when Control Flow tasks are run in parallel checkpoints act a little erratically.
Aucun commentaire:
Enregistrer un commentaire