|
|
|
Grasshopper
 
Group: General Forum Members
Last Login: Thursday, October 15, 2009 9:24 PM
Points: 11,
Visits: 144
|
|
Jack Corbett (7/2/2009)
Well, it depends.
Can you modify the table structure to include the calculated column?
Are the values in conditionvariables changing?
Yes and Yes. I am able to modify the table structure to include the calculated column to include the calculated column. The conditions can fluctuate quite often based on standard test results in our organization.
I'm still testing out the solutions, but will definately report back with my results. Thank you so much.
|
|
|
|
|
Grasshopper
Group: General Forum Members
Last Login: Thursday, October 15, 2009 9:24 PM
Points: 11,
Visits: 144
|
|
So after testing and reviewing my requirements, implementing the solution via SSIS was easier for me. There wasn't a big preformance difference when I processed 10,000 records, but the deciding factor was more the changing requirements variableconditions table.
Thank you once again for your responses.
|
|
|
|
