/Rhino.Etl.Tests/Dsl/UsersToPeopleBulk.boo

 1operation split_name_bulk:
 2    for row in rows:
 3        continue if row.Name is null
 4        row.FirstName = row.Name.Split()[0]
 5        row.LastName = row.Name.Split()[1]
 6        yield row
 7    
 8process UsersToPeopleBulk:
 9    input "test", Command = "SELECT id, name, email  FROM Users"
10    split_name_bulk()
11    sqlBulkInsert "test", "People", TableLock = true :
12        map "id", int
13        map "firstname"
14        map "lastname"
15        map "email"
16        map "userid", "id", int