The following are of SSIS development may be the main reason why people report so much trouble using this set of Microsoft ETL Tools.
When developing SSIS packages, understanding requirements and pushing back on unrealistic requirements. For example, I was once tasked with creating a package that could support an unlimited amount of variables. No need to go any further.
Listed here are simple questions that should be asked during the initial requirements generation phase of the project/task.
- Types of files to be loaded
- Upsert or “Insert & Update”
- Logging & Error output
- Execution Options
- Ongoing Maintenance
- Configurable settings