Comments on Coding Instinct: Object Oriented ETL using RhinoETL

Can you help me how to implement this question in ...

2009-04-05T12:14:00.000+02:00

Can you help me how to implement this question in coding programming c++ using object oriented software development please....The question is for each semester,student needs to register for the subject they want to take for that semester.Each student is allowed to register to up to 15 credits.Each subject consists of 3 credit.During registration,the system will check the student record to fine out whether the student has any debts with the college or not.If the student don't have any debts,then registration is allowed.

With a little bit of code things can become much m...

2009-03-09T22:48:00.000+01:00

With a little bit of code things can become much more maintainable. We started using ssis and found it very difficult to deal with unstructured data. We invested some time in creating custom task, source, transform and destination adapters. SSIS development is now very flexible and fast for us. And if there is something that we do all the time in a package we create a custom component and get reuse that way. In my experience if you should combine etl + coding to deliver the best solution.

There isn't that much code, and it easily extensib...

2009-02-09T07:53:00.000+01:00

There isn't that much code, and it easily extensible, maintainable, works great with source control, easy to deploy, etc

I will preface this comment by saying that I haven...

2009-02-06T15:30:00.000+01:00

I will preface this comment by saying that I haven't tried Rhino yet.

However, being an experienced ETL guy (Informatica, Datastage, DTS/SSIS), I certainly understand SSIS's many limitations and frequently am frustrated by them.

That said, what SSIS IS good at is allowing the developer to build complex ETLs without much coding.

The thought of having to write/maintain even as much code as this seems like a step in the wrong direction from a productivity standpoint, unless the benefits in flexibility and maintenance (not to mention logging, deployment and versioning) are great.

Am I missing something here?

Does RhinoETL provide a feature to insert into ide...

2009-01-06T14:52:00.000+01:00

Does RhinoETL provide a feature to insert into identity columns? For example, pre-populating a fresh database with dictionary/test data?

The performance is more than sufficient for my sce...

2008-12-09T06:23:00.000+01:00

The performance is more than sufficient for my scenarios as I am only processing small tables with only about 1000-2000 rows.

have you mentioned your performance problems on the rhino-tools mailing list, maybe there is something that can be done about them.

I am interested to know what your performance is l...

2008-12-08T23:11:00.000+01:00

I am interested to know what your performance is like with rhino-etl and how much data you are moving?

I have used rhino-etl in the past for similar things and its so much better than ssis, however the engine in SSIS blows away the rhino engine when it comes to high performance ETL's that need to run on regular intervals.

If complexity is high and performance is not an issue I use rhino, otherwise I am stuck with SSIS :(