I haven't used the DSL for Rhino ETL, but I would be curious if the
DSL was handling that input as a separate operation or not. The error
makes me think that your Write operation isn't getting any rows to it.
Have you tried making an explicit operation for the read part of your
process? Also not sure if you should be directly calling the operation
instead of just registering it with the process and then executing the
process.
On Nov 10, 1:56 pm, ChrisR <[EMAIL PROTECTED]> wrote:
> I'm trying to export a database table to a file using the latest trunk
> version of Rhino.Etl and although the file is generated correctly I am
> getting the following exception:
>
> 19:49:19.904 Rhino.Etl.Core.Pipelines.ThreadPoolPipelineExecuter:
> Failed to execute operation writefile.WriteCustomersToFile
> System.InvalidOperationException: Null enuerator detected, are you
> trying to read from the first operation in the process?
> at Rhino.Commons.Guard.Against(Boolean assertion, String message)
> at
> Rhino.Etl.Core.Enumerables.EventRaisingEnumerator.System.Collections.Generic.IEnumerable<Rhino.Etl.Core.Row>.GetEnumerator()
> at
> Rhino.Etl.Core.Enumerables.EventRaisingEnumerator.GetEnumerator()
> at
> Rhino.Etl.Core.Pipelines.ThreadPoolPipelineExecuter.<>c__DisplayClass1.<DecorateEnumerable>b__0(Object)
>
> Here is my etl file:
>
> import System
> import FileHelpers
> import Rhino.Etl.Core.Files
>
> [DelimitedRecord("\t")]
> class Customer:
> CustomerID as String
> CompanyName as String
> ContactName as String
> ContactTitle as String
> Address as String
> City as String
> Region as String
> PostalCode as String
> Country as String
> Phone as String
> Fax as String
>
> operation WriteCustomersToFile:
> engine as FluentFile = FluentFile.For[of Customer]()
> engine.HeaderText = "Id\tCompanyName\tContactName"
> using file = engine.To("export.txt"):
> for row as Row in rows:
> cust = row.ToObject[of Customer]()
> file.Write(cust)
>
> process ExportCustomers:
> input "Northwind", Command = "SELECT * FROM Customers"
> WriteCustomersToFile()
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
