Thanks again.... is there any other way to do this little bit simple bcause in Sql Server 2000 there we have a "Transform Data Task" where we do this task...

Thanks a lot it works COOL........... finally i am able to migrate the data .....

Ya i am doing only Data Transfer ... but as you mentioned using the "Execute SQL Task" i dont see any where source connection and destination connection... so how can...

Its truly a plain Identity Column... and even the destination table has the columns which has the Source..... only difference i am finding is the Identity Column values.... i.e. not...

Thanks for the suggestion but I have tried with that also but still the migrated values seeds are different to the source seeds....

Hi,

 Thanks a lot now i am able to define and still working on something else on this.... i even registered into the site to view the video file for more...

Thanks for the suggestion.... but i have created those too but those variables i am not able to use it for passing the ServerNames, DatabaseNames & userids , Passwords to...

ya i too believe the answer should be

Change the following key to have a value of 2:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft \MSSQLServer\MSSQLServer\LoginMode

(i have checked everything the above one is correct).

Regards,

Subbu.