thanks guys..resolved now...inserted data into a temporary table and used Union all query to get the data.so now i get only 3 rows:)

Yeah..the version where you developed the package should be the same where you deploy it else it will never work.i also experienced this problem sometime back:)

No.you can delete the packages in the project and rebuild and deploy..

Ex: i have 5 pkgs in a project and i dont want 1 package.i'll delete it and redeploy..so that...

Dude,

whatever changes you make to package,follow the steps given below.

1) Go to Solution Explorer and Re-Build the solution.

2) Deploy the package to SQL Server using manifest file and all the...

Ya buddy...source table do have duplicates..I thought i'll implement this scenario with SCD itself but no luck.so i implemented it with LookUp transformation..well to remove duplicates,i used another Look Up...

but i want to use SCD type 1 only..i increased Buffer size to maximum..it works until some rows say 1000 and then any increase is causing that update problem...my source...

Hi Gursethi,

Thank you very much for your valuable time in answering my query. Actually, iam new to Sql server so i am unable to get answer for some of the...

Hi All,

i also got the same error "No more buffers can be stolen"..i checked the Microsoft links and i didn't get any help from that..i use only 3 databases..i thinnk...