Hi,
I am a Microsoft BI Developer and currently working on Pharmaceutical BI project. In this project, Clint wants to integrate his Blaze Advisor rule engine to SSIS so that he can change the rules in Blaze advisor any time and see the effect of it on the source data. Hence, my question is:
How can i integrate the “Blaze Advisor” to “SQL Service Integration Services” (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?
My Trails to Solve this problem:
I have written the rule in the Blaze Advisor & Imported it’s rules into .Net file 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 to it. It is demanding for *.Server & *.Client files there.
– Can you suggest me 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?
I’ll be really greatful to you if you could suggest me an approch for this particular business problem.
Thank You!
Regards,
Sandeep Kusnure