How to handle error while loading data into staging table from excel.

Hi All,

we are importing data using data source and business has some questions like 

1) is there any possibility of error while loading data into staging table and how to tackle it.

2) is there any possibility of partially loading of data into staging table and how to handle it.

I want to in what scenarios the error will while loading data & system will load partial data. Please guide me here

Thanks,