Run an SSIS package from R. Function will check to make sure you can run an SSIS package and it will remove the output file if it exists so as to not append data on top of it.
ExecuteSSIS(PkgPath = NULL, CSVPath = NULL)
Path to SSIS package includin the package name and the package extension .dtsx
Path to the csv output data location including the name of the file and the .csv extension
Other Database:
AutoDataDictionaries()
,
SQL_ClearTable()
,
SQL_DropTable()
,
SQL_Query_Push()
,
SQL_Query()
,
SQL_SaveTable()
,
SQL_Server_BulkPull()
,
SQL_Server_BulkPush()
,
SQL_Server_DBConnection()
,
SQL_UpdateTable()