asked
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][1] [1]: /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.
14 People are following this question.
