Using OpenDataSource - SQL School Video
The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
2009-04-09
2,663 reads
The OPENDATASOURCE command is used for adhoc access to other servers or files in a filesystem. MVP Andy Warren shows how you can quickly use this to access data in other sources.
2009-04-09
2,663 reads
Using opendatasource to retrieve data from Excel files as if querying a table.
2011-03-22 (first published: 2009-01-27)
11,596 reads
Discusses the techniques and reasons to use opendatasource for reading text files in SQL Server 2005.
2007-12-13
9,655 reads
the dates are not stored as dates more like yyyymmdd. My trouble is i do not seem to be able to refer to the dest table in the select query from the source
2003-06-13
Thanks everyone. I will work with what we have. I appreciate everybodys input. --Joe
2003-06-11
DId you happen to install the "SQL Critical Update" utility (more info at ). This is the tool I recall folks saying was causing issues just like you are reporting. More specifically it was running Servpriv.exe , if I recall correctly, seemed to be at the root of the issue. Edited by - antares686 on […]
2003-05-07
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers