Write ETL jobs in pure C#

Paul B.

Rate me:

4.80/5 (14 votes)

29 Mar 2009CPOL7 min read

145.2K

3.8K

An introduction to using Rhino ETL to avoid dealing with designers such as the ones in DTS/SSIS job creation.

sampleetljob.zip
- SampleETLJob
  - ConsoleApplication1
    - bin
      - Debug
    - ConsoleApplication1.csproj
    - Program.cs
    - Properties
      - AssemblyInfo.cs
  - LocalTestRun.testrunconfig
  - Reference
    - Boo.Lang.dll
    - FileHelpers.dll
    - log4net.dll
    - Rhino.Commons.Clr.dll
    - Rhino.Commons.dll
    - Rhino.Etl.Core.dll
  - SampleETLJob.sln
  - SampleETLJob.vsmdi
  - SampleETLJob
    - app.config
    - bin
      - Debug
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        output.txt
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleETLJob.exe
        
        SampleETLJob.exe.config
        
        SampleETLJob.vshost.exe
        
        SampleETLJob.vshost.exe.config
        
        WorkFolder
        
        addresses.txt
        
        names.txt
        
        output.txt
    - DataObjects
    - MainProcess.cs
    - Operations
    - Program.cs
    - Properties
      - AssemblyInfo.cs
    - SampleETLJob.csproj
    - Settings.Designer.cs
    - Settings.settings
    - WorkFolder
      - addresses.txt
      - names.txt
  - Test
    - BaseTestClass.cs
    - bin
      - Debug
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleData
        
        addresses.txt
        
        names.txt
        
        SampleETLJob.exe
        
        Test.dll
        
        WorkFolder
        
        addresses.txt
        
        names.txt
        
        writetest.txt
    - JoinUserRecordsTest.cs
    - Properties
      - AssemblyInfo.cs
    - SampleData
      - addresses.txt
      - names.txt
    - Test.csproj
    - UserAddressReadTest.cs
    - UserFullWriteTest.cs
    - UserNameReadTest.cs
    - YieldReturnTest.cs
  - TestResults
    - Home_HOME 2009-03-29 12_24_01.trx
    - Home_HOME 2009-03-29 12_24_01
      - Out
        
        addresses.txt
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        names.txt
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleETLJob.dll
        
        test.dll
    - Home_HOME 2009-03-29 12_24_59.trx
    - Home_HOME 2009-03-29 12_24_59
      - Out
        
        addresses.txt
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        names.txt
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleETLJob.dll
        
        test.dll
    - Home_HOME 2009-03-29 12_26_50.trx
    - Home_HOME 2009-03-29 12_26_50
      - Out
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleData
        
        addresses.txt
        
        names.txt
        
        SampleETLJob.dll
        
        test.dll
    - Home_HOME 2009-03-29 12_27_06.trx
    - Home_HOME 2009-03-29 12_27_06
      - Out
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleETLJob.dll
        
        test.dll
    - Home_HOME 2009-03-29 12_27_24.trx
    - Home_HOME 2009-03-29 12_27_24
      - Out
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleData
        
        names.txt
        
        SampleETLJob.dll
        
        test.dll
    - Home_HOME 2009-03-29 12_27_48.trx
    - Home_HOME 2009-03-29 12_27_48
      - Out
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleData
        
        addresses.txt
        
        names.txt
        
        SampleETLJob.dll
        
        test.dll
    - Home_HOME 2009-03-29 12_28_07.trx
    - Home_HOME 2009-03-29 12_28_07
      - Out
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleData
        
        addresses.txt
        
        names.txt
        
        SampleETLJob.dll
        
        test.dll
    - Home_HOME 2009-03-29 12_28_28.trx
    - Home_HOME 2009-03-29 12_28_28
      - Out
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleData
        
        addresses.txt
        
        names.txt
        
        SampleETLJob.dll
        
        test.dll
    - Home_HOME 2009-03-29 12_42_11.trx
    - Home_HOME 2009-03-29 12_42_11
      - Out
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleData
        
        addresses.txt
        
        names.txt
        
        SampleETLJob.dll
        
        test.dll
        
        writetest.txt
    - Home_HOME 2009-03-29 13_02_16.trx
    - Home_HOME 2009-03-29 13_02_16
      - Out
        
        Boo.Lang.dll
        
        FileHelpers.dll
        
        log4net.dll
        
        Rhino.Commons.Clr.dll
        
        Rhino.Commons.dll
        
        Rhino.Etl.Core.dll
        
        SampleData
        
        addresses.txt
        
        names.txt
        
        SampleETLJob.exe
        
        test.dll
        
        writetest.txt

Id	Address
1	123 Main St.
2	42 Everywhich way
3	1 Microsoft way
4	1892 Columbo

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Paul B.

United States

I've been a software developer since 1996 and have enjoyed C# since 2003. I have a Bachelor's degree in Computer Science and for some reason, a Master's degree in Business Administration. I currently do software development contracting/consulting.

Write ETL jobs in pure C#

License

Comments and Discussions