thanks Phil,

I just stepped through this and it hung up at adp1.Fill(dt1)

Also, the pop out box says 'OleDBException was unhandled by usercode'

..then

System.Data.OleDb.OleDbException was unhandled by user code. An Exception type...

thank you Phil.  I'm brand new to SSIS, so this is exactly what I needed to hear.  This makes good sense

thanks a ton!
I can't wait to try these options out.  I appreciate the help!

thanks for the quick reply Luis,
I would need to sum up the Invoices as well, but as to only sum them once per Widget.ID (as opposed to multiple times...

Good stuff.  Thank you kindly!

Thank you Eirikur
When you say same order of the composition of the PK, you mean it would be Date (first) and then StoreNumber (second)?  While I was awaiting a...

lol yes...that was a fine way to start the day. Anyway, thanks Steve, I do have some experience with SSIS, but I don't have it set up on my new...

thank you!  Yes, indexes are good and I can return the same info in SQL in less than a second. I'll think about your suggestion t return all the info...