We will have about 200 files (csv, excel, PDF, screen scrape) that all need to go into a SQL db. So there will be a unique procedure for most data sources 

Only 2 ideas we have so far are:

1. Write code to programmatically load each data source in as needed and write code to insert as needed (this is the simple way but maybe most time consuming)
2. Write an XML map for each file that maps column from the source to columns/tables of the destination SQL DB.. But then writing code to interpret this custom XML mapping file could get complex?

Any other tools or methods we should consider? I though maybe SSIS could help somehow ? This seems to be the type of project BizTalk was made for right? But that is too expensive..