Post reply

How To solve the problem I Read one or more flat files For Particular folder .

  • September 12, 2011 at 4:27 am

    #243137

    Hi Steve Jones

    I have one folder for example Empdetails(foldername)

    in that three .csv files are there that having different columns

    (Ex:1) epersonal.csv file that contains three columns like [empid,efirstname,elastname])

    2)eaddress.csv file that contains four columns like [ecity,edistinct,estate,ecountry]

    3)eotherdetails.csv file that contains four columns iike [egender,emarried,sal]

    )

    I want to transfer the flat files data into Oracle destination Table Without Duplicates data

    Oracle destination Table Format

    EmpDetails

    Empid Ename City Distinct State Country Gender Married Sal

    100 Hari Hyd Hyd A.P INDIA Male Unmarried 150000

    Pls help me

    step by step procedure

  • September 12, 2011 at 8:07 am

    #1380029

    You haven't well framed the question. Is this a one time transfer? Are they the same format? Do the names of the files change?

    Setting up a one time transfer is trivial. One source, one destination, and 5 transfer tasks in a package. This gives basics: http://qa.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/72493/

    However if you are looking to add more to it, then someone isn't likely to build the package for you. If you have different file names, you need a for loop that scans the files in a folder. Search for that technique or ask that specific question. If you need to handle different formats, ask that.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

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

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