September 20, 2002 at 1:54 pm
In general, which will perform better? I'm dealing with several thousand records and creating summary records in a reporting table based on key fields. I am unable to get certain values by using joins...so I have to choose. Any thoughts?
September 23, 2002 at 10:41 am
My vote is ADO connection. Easier to control and troubleshoot. Just personal preference.
Steve Jones
September 23, 2002 at 11:58 am
Thanks for the reply. I'm using ADO connections now in a series of 10 packages that has added significant processing time to a process currently in place. I'm trying to come up with ways to reduce that processing time, and was wondering if re-coding the transforms to use Lookups might be an option?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply