Is it possible to have a package (or any other automated
functionality) that will UPDATE a table as opposed to INSERT. This is
something that I have cared to do numerous times but for the life of
me I can never get anywhere with it.

Jeff - what 'triggers' the update? If it is just running a script, you can
use an ExecuteSQL task. Alternatively it might be the data driven query task
that you need.
Details of both in BOL or post back if you want clarification.
HTH,
Paul Ibison

[quoted text, click to view]


Well, my situation goes like this. Im exporting data into Excel where
it is being manipulated and then returned to me to so I can in turn
update the database. I wish this wasnt the case but it is. I was
hoping that using packages could be the solution to how I can easily
accomplish this but I couldnt make it work.

To answer your question, I will trigger the update manually.

Sorry Jeff, I'm still not entirely clear on this and what it is that you are
having problems with :). Do you want to cut out the Excel bit entirely and
have the updates done in code? Or do you want to know how to import the data
from excel and have updates done as a result? If the latter then you could
have the OLE DB Command object perform the updates for each row of the excel
data source.
HTH,
Paul Ibison