what is the best practice for testing projects of biztalk and ssis?

what is the best practice for testing projects of biztalk and ssis, they are tools for data migration and manipulation - which points need to be tested?...package execution successfully? Data samples or exhaustive testing? and so on? - Is automation testing will be better? if yes which tool?
- any other advice?