Organizing Business Rules in SSIS

Hot Topic

2nd Drop Down Box not Initiating
Bandwidth check?
Value method of xml data type not deterministic, xml column not accessible in 'deleted' table
SSAS service does not start
Avoiding deadlock
Automate partition creation
Connection Manager in SSIS packages
SET IDENTITY_INSERT
OLEDB question
ODBC Destination in SSIS

SQL Server

SQL Sever 2005 only has client side?
Mirroring and orphaned users
Cannot Connect to SQLExpress
SQL 2005 Merge Repl suddenly stopped working
Code Completion of SQL Statements in 2005
Exporting Report Builder Tabular Report to CSV
(Error) Conversion from "DT_TEXT" to "DT_WSTR" is not supported.
Data Driven Subscription - Will the Report run for each parameter ?
SQL Agent Limitation (SQL 2005)
Merge Replication with SQL Mobile Server 2005 / SQL Server 2005

Organizing Business Rules in SSIS

Hi All,

I'm pretty new to SQL Server 2005 and I'm wondering how to organize my
business rules efficiently.

I'm willing to create a Package with several Data Flow Task in my
Control Flow, each Business Rule will be encapsulated in a Data Flow
task. I guess this is possible in SSIS but I can't find how my data can
be send from one data flow to another one. I definitly don't want my
dataset to be parsed completly for each business rule.

Does anyone have an idea how to implement this in SSIS

Kind regards,

Sebastien.

Answer this question

Organizing Business Rules in SSIS

Richard D Line
Thanks for your answer! I'll try the Raw Data file!
PL_Pit

Yes, there is a very good in-built method for doing this. Use raw files to pass data between different data-dlows.

Alternatively you could use an in-memory recordset as explained here: http://blogs.conchango.com/jamiethomson/archive/2006/01/04/2540.aspx but I don't recommend it!. (Read the comments as well).

-Jamie
Organizing Business Rules in SSIS

Answer this question