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.
In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…