SSIS 2005:
Is there any other Best Practice than using a Lookup Task do an update via
OLE DB for known IDs and doing an insert for unknown IDs afterwards to Update
a table from an imported table?
If doing so the updates are extremely slow. We used a staging table and a
"update from where exists" statement before in DTS but with SSIS I hoped to
find a more elegant way doing this.

What I forgot: In a blog I read about a planned (or hoped to get)
"Update Sql Server Destination" Object. Is something like that really
planned. It would be the most helpful component for doing updates at high
speed I think.