R language data load in SQL

I like to store stuff in SQL Server tables. Data can be just about anything and it can be stored using TSQL in numerous stages of conversion in a table. Large storage is available in ntext, binary, varbinary, etc ...

But first you've gotta load ... it.

CREATE SCHEMA [rdata]
CREATE TABLE [database].[rdata].[rfile](
   [strR][nvarchar](MAX}
   )
CREATE TABLE [database].[rdata].[rfileIdx](
   [idx][int]IDENTITY(1,1)
       [strR][nvarchar](MAX)
   )
BULK INSERT [database].[rdata].[rfile]
'c:\R_data_output\filename.rrr'

INSERT INTO [database].[rdata].[rfileIdx]
   SELECT [strR] FROM [database].[rdata].[rfile]

If all goes well, you'll receive no red error messages and you'll have lines of "data" in an indexed table. I'll wager you'll run into the single line table next ...