If I read the question correctly then you have basically this type of
scenario

A central subscriber with multiple publishers.

Sorry for the replication terminology but I think that is what you have.

Build a package that does what you want from one of your Publishers.

You can then execute this package for each of your publishers and change the
connections for the Source(Publisher connections) by utilising ideas here

Connections
(http://www.sqldts.com/Default.aspx?101)

You are looking for the DataSource and Catalog properties of the SQL Server
connections.

If the way the data is held at each publisher is the same and the way it
needs to be inserted at the sibscriber is the same then this will work.



--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org