SSIS experts come here...

[Renault]

ssis  .packages create chesi execute chesaka.;.... how do u make sure the data is transfered correctly from source to destiation?  ee qn ki ela answer cheyali? there will be millions of rows..

how to validate the data?

 

[tables]

rowcount ani oka component untadi.... daantlo total rows transferred log avutai.. aa variable ni oka audit table lo log chesko.

or more manual method is take row count in source in a varibale ; process tarvata destination lo count teesuko and log them in a audit table on process complete task.

[Desi_guy]

5 hours ago, tables said:

rowcount ani oka component untadi.... daantlo total rows transferred log avutai.. aa variable ni oka audit table lo log chesko.

or more manual method is take row count in source in a varibale ; process tarvata destination lo count teesuko and log them in a audit table on process complete task.