Stack Overflow
Stack Overflow

Questions tagged [rhino-etl]

Rhino ETL is an open source Extract, Transform and Load (ETL) library for .NET

30 questions
1
vote
0 answers

Sequential branching / branched sequential pipeline

I would need some help with the pipeline of the Rhino ETL framework. Required is a kind of operation chaining which, Allows branching, Operates sequential (row by row), Returns the original input row to the pipeline which entered the branch. …
Florian D.
  • 250
  • 3
  • 9
1
vote
1 answer

RhinoETL merge table with webservice results

I have a table in SQL Server that is populated from a Web Service. I want it to be refreshed on a scheduled basis. I would like to have something similar to an SQL Merge operation. That is i define my source (Web Service) and my target (SQL Table)…
Giannis Paraskevopoulos
  • 18,261
  • 1
  • 49
  • 69
1
vote
2 answers

How do I enable logging in RhinoETL process?

I have nearly completed my first ETL process that uses Rhino ETL, and I've been able to figure out the way to use the API by referring to the tests. Great. I have data moving through the pipeline and being written to the db. However I can't seem to…
nocache
  • 194
  • 1
  • 7
1
vote
1 answer

Rhino ETL - loading large pipe-delimited files

We've got to load large pipe-delimited files. When loading these into a SQL Server DB by using Rhino ETL (relying upon FileHelpers), is it mandatory to provide a record class? We have to load files to different tables which have dozens of columns -…
Alberto
  • 333
  • 2
  • 16
1
vote
1 answer

How can I use FluentFile in Rhino ETL DSL?

I have been playing around with the Rhino ETL library and really like the direction that it's going. However I have found that the bad part about it is the documentation is sparse and there doesn't seem to be enough good information on how to create…
Nathan Palmer
  • 1,970
  • 1
  • 20
  • 28
1
vote
1 answer

Rhino-ETL Conditional Operation

I want to check the value of a row field value and depending on the value run a specific operation. Can this be done. Part of the code is below public override IEnumerable Execute(IEnumerable rows) { foreach (Row row in rows) …
user204588
  • 1,613
  • 4
  • 31
  • 50
0
votes
1 answer

How can I separate rows with different RowTypes using FileHelpers?

For example, I have the next file test.txt with two Rows: Type00007P 008 PPL Type00230J 190 1 And the next classes in my code to use the Rhino-ETL Nuget to insert those rows on my DB: public class Type00007P { [FieldFixedLength(10)] …
slopezjur
  • 15
  • 6
0
votes
1 answer

FileHelpers - string length issue?

I'm moving some data about using rhino.etl One of the tables I'm moving has a column which stores a fairly large chunk of text for each row - though it's not that huge and there are only about 2000 rows. When running the job I get: A first chance…
user156888
0
votes
1 answer

Rhino ETL C# DelimitedRecord

I would like to know if are there a way to ignore the DelimitedRecord if it found in my file a string like "70,000 - 99,999" File Sample: 1, "70,000 - 99,999" 6, "20,000 - 99,999" 8, "50,000 - 99,999" [DelimitedRecord(",")] public class MyClass { …
Daniel Silva
  • 1
  • 1
0
votes
1 answer

Log the exception in a log file if there is conversion exception

I need to log the exception message if any conversion exception comes while iterating data of a file and then continue with next data. For example, if the input file has 10 records and there is exception raised due to 7th record. Then I need to…
Coding man
  • 957
  • 1
  • 18
  • 44
0
votes
1 answer

How do we get Rhino ETL to redirect bad rows to a different destination table?

We are migrating an SSIS package to Rhino ETL. The SSIS package currently outputs bad rows to an alternate destination table where all columns are nullable and varchar. Good rows go to the real destination table but upon error, it will redirect the…
Dave
  • 31
  • 5
0
votes
1 answer

Rhino ETL - cancel EtlProcess part way through

I have a Rhino ETL process that performs several sequential actions, the first of which is to go to a SQL Server database and retrieve some rows (i.e. the "extract" part of the overall process). I want to make the EtlProcess bomb out if there were…
mwrichardson
  • 1,148
  • 1
  • 8
  • 12
0
votes
1 answer

Internal compiler variables appearing in the debugger Locals pane with Rhino ETL

If you disassemble C# you often see temporary variables inserted by the compiler with names such as: CS$1$0000 But what would cause them to appear in the debugger Locals/Auto panes? A colleague of mine is trying to maintain a tool written using…
Daniel Earwicker
  • 114,894
  • 38
  • 205
  • 284
0
votes
1 answer

Rhino ETL supports which database?

I was choose to integrate Rhino ETL tool in my application. In my application i am using various databases like sql server, oracle, mysql, sybase, Informix, db2, ingress. Will Rhino support these databases and which ones? And also can I migrate…
venkat
  • 178
  • 2
  • 12
0
votes
3 answers

SSAS with Rhino ETL?

Is it possible to query an SSAS database using MDX and use this as a datasource for Rhino ETL? I am talking about making an OLE DB connection to the SSAS instance here. Thanks!
Mike Gates
  • 1,874
  • 3
  • 21
  • 40
1
2