following method worked out for me

for this example i have used table called table1 which has single column column1.

create table table1

(column1 int)

I have inserted values 1,2,3,5,9...

That means, If I have to run SSIS in production , I cant purchase only SSIS, i have to purchase Entire SQL Server 2005

Yes, As u told i'm not suppose to drop all the rows and reload. It should insert or update or ignore.

Guru