I am a Microsoft Business Intelligence (BI) Developer and currently working on a Pharmaceutical BI project. The client wants to integrate his Blaze Advisor rule engine to SQL Server Integration Services (SSIS) so that he can change the rules in Blaze Advisor any time and see the effect of it on the source data.
How can I integrate the "Blaze Advisor" to "SSIS” (Microsoft SQL Server ETL tool) which will use my Business Rules (written in Blaze Advisor) in the transformation task and process all my source data with the same business logic?
I wrote the rule in the Blaze Advisor and imported its rules into .Net files, which includes *.Server, *.Client and some other files. I have used the DLLs in this solution in my SSIS script task, but it's not supporting, and it is demanding for *.Server and *.Client files there.
Can you suggest a way to integrate SSIS with Blaze Advisor?
How can I use the Blaze Advisor's .Net output files as DLLs into my custom transformation?