I want to port data from one server's database to another server's database.
The databases are both on a different mssql 2005 server.
Replication is probably not an option since the destination database is generated from scratch on a [time interval] basis.
Preferebly I would do something like
where rule1 = true
I think what you want to do is create a linked server as per this msdn article. You would then select using a 4 part object name eg:
Select * From ServerName.DbName.SchemaName.TableName