SQL Server2012- data transfer from SQL Server database to different server on Hyper-V using SSIS package
I have SQL Server 2012 on local server, Visual studio and recently installed another windows server 2012 on Hyper-V for practice purpose, on Hyper-V instance server I installed SQL Server 2012. I know how to link servers to transfer data, but I want to create SSIS project to transfer data from local host database to another database on Hyper-V. now I am trying to create connection manager for OLE DB Destination to get server name from Hyper-V and assign to table, but only option I have to choose is local host server name. I am new to this. please help me. I tried ODBC destination and Destination assistant but I have no success. ![alt text] : /storage/temp/1405-bbbb.png
I figured it out ! you have to have a linked server in order to create Ole DB Destination manager, type Name of linked server and use SQL Server authentication account to access data from linked server database.