question

SimonMeduka avatar image
SimonMeduka 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
sql-server-2012visual-studio-2010windows-server-2012
bbbb.png (18.0 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
SimonMeduka avatar image
SimonMeduka answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.