SSIS:

  1. How to design a package:  There are 2000 excel file and need to  import in SQL server
  2. How to design a package:  Excel to SQL server destinations with file name starts with “finance” only. 
  3. If there is parent package and child package. There is an error in one of the packages. How can we identify whether error in parent package of child package?
  4. Duplicate records needs to Delete from Destination on the basis of Source and import it and put it into another destination
  5. All records from excel file to insert in SQL destination except first 10 records and Rows 15 to 40 needs to insert in sql server rest don’t