are you copying from all servers to your own? one to many?
many to many? Are the tables the same schema on each
server? Need more info because this will affect the syntax
of the script.

Generically speaking, look into creating linked servers
between the servers, and either use a union all or join
statement to get the data moved.

Perhaps a DTS package would work for you as well. you can
create on easily by right clicking on the database, choose
all tasks, and either import or export data, depending on
whether you are on the source or dest server.
then save the package before you run it.

Hope this helps.

[quoted text, click to view]