Tuesday, February 14, 2012

Business Rules Integration in SSIS

Similar to the BizTalk Business Rules engine does the SSIS provide any support for independent business rule management?
I would guess that through the use of Embedded CLR we can invoke the Business rules stored in the Business Rules Engine (either Biztalk Rule Engine or ILOG Rule Engine). Is there a construct in the SSIS similar to the BizTalk Call Rules Construct in the Biztalk Orchestration.

If this mechanism is not the preferred mechanism then are there any other mechanisms offered by SSIS which facilitate the use of Business Rule Engine Components within SSIS which make it easier to manage the business rules outside of the deployment.

Thanks
You can use a Script Component or Script Task to call any .NET resource from within the data flow. There isn't a built-in rules engine in SSIS, though.|||But the script manager is restricted to VB.NET as the code development language. Is there a way we can use C# as the code development language.

Is there an existing prototype for the development of the code.

Regards
Vinit
|||

learning4fun wrote:

But the script manager is restricted to VB.NET as the code development language. Is there a way we can use C# as the code development language.

No, not yet. You'd have to reference your C# stuff from within your VB.net code.|||

SQL Server 2008 will support script components written with C# (at least, the current CTP supports it).

You can also create your own SSIS components in C#, and use them directly. Or build a C# assembly, and reference it from the script task, as Phil mentions.

No comments:

Post a Comment