---
title: "OPENROWSET (DMX) | Microsoft Docs"
ms.custom: ""
ms.date: "03/02/2016"
ms.prod: "sql-server-2016"
ms.reviewer: ""
ms.suite: ""
ms.technology: 
  - "analysis-services"
  - "analysis-services/data-mining"
ms.tgt_pltfrm: ""
ms.topic: "language-reference"
f1_keywords: 
  - "OPENROWSET"
dev_langs: 
  - "DMX"
helpviewer_keywords: 
  - "OPENROWSET statement"
ms.assetid: 8c8b61b4-2bf6-46c7-8976-51484004dc22
caps.latest.revision: 34
author: "Minewiskan"
ms.author: "owend"
manager: "erikre"
---
# <source data query> - OPENROWSET
[!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx_md](../includes/tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md)]

  Replaces the source data query with a query to an external provider. The INSERT, SELECT FROM PREDICTION JOIN, and SELECT FROM NATURAL PREDICTION JOIN statements support **OPENROWSET**.  
  
## Syntax  
  
```  
  
OPENROWSET(provider_name,provider_string,query_syntax)  
```  
  
## Arguments  
 *provider_name*  
 An OLE DB provider name.  
  
 *provider_string*  
 The OLE DB connection string for the specified provider.  
  
 *query_syntax*  
 A query syntax that returns a rowset.  
  
## Remarks  
 The data mining provider will establish a connection to the data source object by using *provider_name* and *provider_string,* and will execute the query specified in *query_syntax* to retrieve the rowset from the source data.  
  
## Examples  
 The following example can be used within a PREDICTION JOIN statement to retrieve data from the [!INCLUDE[ssSampleDBDWobject](../includes/sssampledbdwobject-md.md)] database by using a [!INCLUDE[tsql](../includes/tsql-md.md)] SELECT statement.  
  
```  
OPENROWSET  
(  
'SQLOLEDB.1',  
'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security     Info=False;Initial Catalog=AdventureWorksDW2012;Data Source=localhost',  
'SELECT TOP 1000 * FROM vTargetMail'  
)  
```  
  
## See Also  
 [<source data query>](../dmx/source-data-query.md)   
 [Data Mining Extensions (DMX) Data Manipulation Statements](../dmx/dmx-statements-data-manipulation.md)   
 [Data Mining Extensions (DMX) Statement Reference](../dmx/data-mining-extensions-dmx-statements.md)