Hi there, I need to update a table in Batch Process as the production data is over 100 million Rows. So Can any one give a step by step process to do the batch update here is what the im doing now in development step 1 : data flow task -> get the records from source db temp table destination step 2 : Sql Script task -> write an update statement like this UPDATE Table1 SET Table1.Field1 = StagingTable.Field1 FROM Table1 INNER JOIN StagingTable ON Table1.Field2 = StagingTable.Field2 Now what should i do or modify to do a batch update Any Ideas ? Thank You

Are the source and destination tables in the same database? Because if so, I would use a stored procedure for this, not an SSIS package (or at least, the package would just call the stored procedure).