migrate objects between SQL2005

I got 2 development servers, I m triyng to move some data from 2 tables to other tables from other database located in other server.

I was using Sql Server 2005 Business Intelligence Development Studio to acommplish this, but when i debug it is shows me error.

someone can tell me the right steps to do this?

If you are using a windows authenticated account to access both servers, just right-click the table in the source database, go to Script Table as --> CREATE to --> New query editor window.

Once the script is generated, right-click in your script and go to Connection -->Change Connection, and connect to the other SQL Server. Once connected, select the appropriate database, and run the create script to add the table.

Then you can run a simple insert statement to post records from the source table to the new table using fully qulified naming. For example:

Insert into TargetTableName
Select * from SourceServerName.SourceDatabase.dbo.SourceTableName

sql