I was thinking to create something like linked server which i could read data from a remote server using SSIS. My question is, can i do that in SSIS which i will only need to read data from a remote server and join with local server tables in a view! How to do that in SSIS?? Servers i am using are SQL Server 2005.