SSIS/BI

SSIS Business Rules Engine

SSIS Business Rules Engine I am by no means a data warehouse or SSIS expert but I have been forced to learn with one of my latest projects. One of the requirements that came out of the analysis and design phase was a client request for a “rules engine” within the data warehouse loader that could be “easily configured” with no code changes. The solution chosen is fairly straight-forward. It required one custom-table (called BusinessRules) and relies on Reflection and the Script Component in the SSIS...
  • Share This Post:
  • Share on Twitter
  • Share on Facebook
  • Share on Technorati