Have you tried putting input "Northwind", Command = "SELECT * FROM
Customers" into a separate operation? Looking at the only example I
could find for the DSL at
http://ayende.com/Blog/archive/2008/01/16/Rhino-ETL-2.0.aspx
I don't see any indication you can directly put the operation code in
the process block.
On Nov 11, 5:29 am, ChrisR <[EMAIL PROTECTED]> wrote:
> I'm sure it is a problem with the DSL as it works fine when
> implemented in code, I'm just not very familiar with using the DSL.
>
> On 10 Nov, 23:45, webpaul <[EMAIL PROTECTED]> wrote:
>
>
>
> > 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()- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
