Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS over linked server??????

Author  Topic 

ashu2409
Starting Member

1 Post

Posted - 2009-12-21 : 09:14:10
Hi all,

i want to select the data from one server and insert into another server's table.database and table's structure are same.

what should i use....
SSIS or linked server..???????????
and how???????
which one is faster for bulky records.????????

thanks in advance.

Thanks,
Ashish

svicky9
Posting Yak Master

232 Posts

Posted - 2009-12-21 : 16:15:59
Quick way
Go to start --> run
Type dtswizard(If you have SSIS installed on your machine)

A wizard should pop up and the rest is magic

http://www.sqlserver007.com
Go to Top of Page
   

- Advertisement -