SmartConnect and Linked Servers
Sherry Whitten asked 6 years ago
Will SmartConnect integrate data into Linked Servers? We are using it in our main SQL installation, but the client has a need to integrate into another SQL server as well. Thanks in advance.
Answers
Patrick Roth Staff answered 6 years ago
It should work fine – i’m pretty sure I’ve worked with a couple of customers that I knew for sure that the source was a linked server (lots of times I don’t know the source).
So that said, there isn’t anything in SmartConnect that sets the ANSI_NULLS and ANSI_WARNINGS to OFF. So you could either enable them on your SQL Server as defaults and SmartConnect should use that on connection. or set in the query and that should work as well.
So that said, there isn’t anything in SmartConnect that sets the ANSI_NULLS and ANSI_WARNINGS to OFF. So you could either enable them on your SQL Server as defaults and SmartConnect should use that on connection. or set in the query and that should work as well.
Sherry Whitten replied 6 years ago Patrick,
Thanks for your reply! We need the destination to be a linked SQL Server. Think that will work too? The source is likely a flat file of some kind.