dpull_data: Direct pull data from SQL server via SQL query into flat file...

Description Usage Arguments Value Note Examples

Description

This function pulls the data from SQL server directly into flat file via StreamReader class via SQL query and returns data.table and data.frame object.

Usage

1
dpull_data(connectionString, sqltask, showprogress = FALSE)

Arguments

connectionString

Connection string to SQL server.

sqltask

SQL query for selecting data on SQL server.

showprogress

Showing progress (default value is FALSE).

Value

Returns data.frame and data.table object.

Note

How to set up SQL Server connection string see set_connString.

Examples

1
2
3
4
## Not run: 
dpull_data(connectionString, "SELECT * FROM dbo.TableName")

## End(Not run)

martinkabe/RSQLS documentation built on June 30, 2019, 10:59 a.m.