Hello,

I've got a questing regarding updating existing data in a SQL Server
table from an Excel file.

The situation (simplified):

Source:
Excel file containing (PK,value)

Target:
SQL Server table contating (PK,value ,DATETIME)

I would like to "merge" the excel, into the SQL Server table. If the
value is different than the SQL, update the SQL and change the datetime
to current date, and if it's the same, don't do anything.

I've tried several combinations using SSIS, but i can't find a way to
do this and avoid using a temporary staging table. Wasn't DTS all about
avoiding staging tables?
Another alternative i've found is to run a SQL Command for each row in
the excel, to launch a stored procedure on the server to perfrom an
"upsert" with this logic built in. The problem with this way, is that
the SQL Command is not considered a "destination" by SSIS, and i gives
warnings...

Is there a simple and "right" way to do this? I can't be the only one
who has encountered this issue... :-)

Thanks in advance!

We are also encountering a similar issue. Just as with DTS it seems
that SSIS is good with pulling bulk data. The problem we are running
into is how to run update commands to update information in a summary
table based on values returned by querying data in a SQL 2000 database.

No one answered, so i guess the best method is still using a staging
table...
This also yeilds the best performance too, from what i've observerd.

shlomoid wrote: