How do I integrate SQL Server Integration Services and Blaze Advisor?
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
March 21, 2008 6:58 PM
UPDATED:
May 28, 2008 1:46 AM
RELATED QUESTIONS
- Error messages in Business Intelligence Development Studio on SQL Server Integration Sevices
- a question about IMPORT/EXPORT from the SQL 2005 Migration
- Can I learn SAP BI?
- How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel
- update the tables in to two server using a single ssis package
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
