I'm am doing some research on using Rhino ETL for an integration
between two systems. What I would like to do is build a boo script
that will define 3 types of operations
1. Create a new database table
2. Input: Select data from the source database
3. Output: Insert data into the destination database
Obviously steps 2 & 3 are handled already using Rhino ETL.
For step 1 I was trying to avoid typing SQL to create the table; so I
tried something like this:
import MySoftware.Sync
operation create_table:
tableName = 'Foo'
columns = {
'Id' : 'int',
'Name' : 'varchar(50)',
'Abbreviation' :
'varchar(50)'
}
// Call a .NET class to create
// a new table in the database
database = DatabaseDefinition("test")
database.CreateTable(tableName, columns)
process SyncData:
create_table()
input "test", Command = "SELECT * FROM Orders"
In the .NET assembly I am using SMO to create tables in the database.
I get an exception when executing, I think because the result of
create_table() does not produce any output.
Is there another way I could accomplish this using Rhino ETL?
If not would you share any suggestions on how to extent Rhino ETL to
support table creation before ETL process.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rhino-tools-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
