create TABLE [dbo].migration_temp(KeyField int not null)
GO

create table dbo.Process(keyFieldId int NOT NULL, isProcessed bit NOT NULL default((0)))

   insert into dbo.Process(keyFieldID)
   SELECT keyFieldID FROm SourceTableView

		WHILE (SELECT COUNT(*) FROM dbo.Process WHERE isProcessed = 0) > 0

		INSERT INTO dbo.migration_temp(KeyField)
		SELECT TOP 100 KeyFieldID
		  FROM dbo.Process with (nolock)
		 WHERE isProcessed = 0

		 UPDATE tgt
			SET tgt.isProcessed = 1
		   FROM dbo.Process tgt  with (nolock)
		  inner join dbo.migration_temp src 
		  on src.KeyFieldID= tgt.KeyFieldID

quote:

---

Originally posted by avlakshmi77

Hi

I created one ssis package. checked for 1000 records. it is working fine. here i getting whole data at a time.
But in live system having lakhs of records. Retriving the data from different server. Some times it is giving 'sql time out exception'.

Some one suggested me to the use batch process.
can u suggest how to use batch process.

thanks in advance.

---