General information
Forum:
Microsoft SQL Server
Title:
Reading data from an external source
Hi all, good monday (under the snow for some, grrr)
I have an external datasource than I want to have accessible into SQL Server 2000. That source is defined as a system DSN
I can, with DTS, import the values, I've tried it, it works. But I want more than that.
Is it possible to define those external tables, so they are seen as SQL Server tables, giving the users the possibility to issue DML against those tables (even joining them with real SQL Server tables) ???
I've done it in Oracle, but I don't know how to do it in Sql Server
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only