1. Update records the in the destination table if it exists in the destination table else create the new record. 2. The student name is required. 3. The student must be a child of one of the defined in the master table. 4. Some data conversions logic.
I wouldn't call those "business rules", they sound mostly like data integrity rules. You can do 1 through 3 in SQL Server easily, and in fact you should have constraints to guarantee 2 and 3. Number 4 is possible in SQL Server depending on how elaborate the conversion is.
These could also be done in SSIS, I'm not an expert on it but I know you can do lookups and conditional logic to support 1-3, and is well suited for number 4.
1. Update records the in the destination table if it exists in the destination table else create the new record. AS suggested by Rob you can use lookup for this see logic in below link
2. The student name is required. use conditional task with an expression to check if studentname has a valid value
3. The student must be a child of one of the defined in the master table. again a lookup onto master table on related field 4. Some data conversions logic. use derived column or data conversion transform
see options inline above
------------------------------------------------------------------------------------------------------ SQL Server MVP http://visakhm.blogspot.com/
Question
Posted - 05/25/2012 : 14:04:41
