Thanks for information. Is there a way to write an SSIS which reads a table columns from one SQL server and transfers into another SQL server? I do not wish to use linked server. Can a query be used to join table columns across databases from 1 sql server and input as 1 table into db of 2nd sql server? Any thoughts appreciated