I am looking at some possible enterprise based solutions for handling file importing and trying to standardize one place to setup file imports and business logic / validations on the import and processing. I know this is a very broad point and SSIS has been my ETL tool of choice when doing any of this except for any deep business rules. Looking to see does BizTalk have better ways to handle that. Some examples would be:
- Standard File Import file type filtering
- Checking for things such as file header etc. is there
- Validating data types possibly on columns prior to importing to a SQL database table for example.
- Applying business rules and then flagging things that need to be changed in the file for a visual the end user can change a field for example.
Not sure any one tool is feasible to do all of these things but looking even for the 90/10 rule that much of it can be done possibly. But the idea of importing files into one portal where then the user can modify things and apply and retry is what I am looking for.