Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

linked server Expand / Collapse
Posted Tuesday, May 20, 2014 1:49 PM


Group: General Forum Members
Last Login: Thursday, December 1, 2016 2:45 PM
Points: 2,015, Visits: 3,809
We are not using linked server much in our environment, occassionally we do a temp linked server to do some adhoc query or import some data. For all other data load, or ETL we are using SSIS. Mostly data source/destination are between SQL servers and Oralce.
I prefer SSIS vs linked server.

Any pro and cons comparing linked server vs ssis, any security issue we should consider for linked server? In which situation link server is in most advantage to use comparing with other approach?

Post #1572884
Posted Wednesday, May 21, 2014 9:27 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 2:19 PM
Points: 948, Visits: 7,148
SSIS is much more efficient.
As I find SSIS fiddly to work with, I sometimes start development with linked servers and then move to SSIS once I have the correct logic.
Post #1573244
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse