Learn R Programming
RemixAutoML (version 0.5.0)

SQL_Server_BulkPull: SQL_Server_BulkPull

Description

Pull data from a sql server warehouse using bulk copy process

Usage

SQL_Server_BulkPull(
  Server = NULL,
  DBName = NULL,
  TableName = NULL,
  Query = NULL,
  FinalColumnNames = NULL,
  SavePath = NULL,
  SaveFileName = NULL,
  DeleteTextFile = TRUE
)

Arguments

Server

Server name

DBName

Name of the database

TableName

Name of the table to pull

Query

Leave NULL to pull entire talbe or supply a query

FinalColumnNames

Supply this if you supply a query that isn't a select * query

SavePath

Path file to where you want the text file saved

SaveFileName

Name of the text file to create

DeleteTextFile

Remove text file when done loading into R

See Also

Other Database: AutoDataDictionaries(), ExecuteSSIS(), SQL_ClearTable(), SQL_DropTable(), SQL_Query_Push(), SQL_Query(), SQL_SaveTable(), SQL_Server_BulkPush(), SQL_Server_DBConnection(), SQL_UpdateTable()