Question

How do I integrate SQL Server Integration Services and Blaze Advisor?

SQL Server, Business Intelligence, SQL Server integration/interoperability, SSIS

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?

You will probably need to contact Blaze Advisor and see if they have an SSIS module which can be used to drive the changes.

Another option would be that you setup all the settings within SSIS to be dynamic and have the package first query for all the settings from the Blaze Advisor database (I assume that it has one) and then adjust the SSIS package based on the output from the Blaze Advisor database.