Post reply

extracting and loading data into Oracle using SSIS

  • May 3, 2007 at 2:11 pm

    #116584

    is it possible to extract from Oracle, transform (preferably in the buffer) and load data into a Oracle db using SSIS? is there any white paper/ article on the process?

  • May 7, 2007 at 11:22 am

    #704729

    Well Shahab I have exactly this thing going on my project.

    But for the sake of scalibility and options for re-runs and late / early arriving data. I download oracle data into xmls with their schema and then run jobs to load data from scheme. To preserve touching the production system and keep integeration little decoupled. Anyway that is my design ... you could use odbc connection to oracle client, if i am not mistaken and do the data pulling.

    Peace out.

    FP

    FP

    True Love is Like A Ghost. Everyone Talks About It & Nobody have seen it.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply