O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How to do it...

  1. In RStudio, open a new script file (File | New File | R Script). Save the file in the Chapter08.R file.
  2. Install the RODBC package and load the library to memory. You can use the following code for this task. Highlight the code in RStudio and press Ctrl Enter to execute the code. Note that you need to have a web connection in order to install a package:
# Install RODBC library 
install.packages("RODBC"); 
# Load RODBC library 
library(RODBC); 
  1. In SQL Server, create a SQL Server login named RUser, with the password Pa$$w0rd. Create a database user in the AdventureWorksDW2014 database for this user and add it to the db_datareader role. You can execute the following code in SSMS to create this login and user:
 -- Add Ruser ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required