Post reply

Load data with Data Pump Task

  • February 17, 2003 at 9:48 am

    #159664

    I have need to load data from file to table with Data Pump Task

    The file is on the type:

    IT0003145718|||||101|10002||

    IT0003228431|||||1000|100000||

    IT0003383897||||BSKFIN||||

    (in the last row, at the end of the row is not present a return carriage)

    Now, In the Connection Properties -> Properties

    I have selected the following:

    Delimited Columns are separated by Characters(s): Selected

    File Type : ANSI

    Row delimiter : {CR}{LF}

    Text qualifier : <none>

    Skip rows : 0

    First row has column names: uncheck

    Now, when I execute the DTS, the last row of the file is not loaded in the table.

    If, I add a return carriage in the end of the last row, the row is loaded

    Why??

    I have need to load the file in the table on database, to prescind from the fact that is present or less

    a return carriage in the end of the last row

    excuse me for my English

    Help me, please

    Bye bye

    Flavio

  • February 17, 2003 at 3:53 pm

    #449155

    If you select {LF} as the row terminator you'll be able to import all the rows in the file. You'll get an extra column that has the carrige return character in it.

    You can either, a)import the file into a staging table that has an extra column then insert the records into your destination table, excluding the last column, or b) change the transformations in the DataPump task to exclude the extra column.

    Thanks

    Phill Carter

    --------------------
    Colt 45 - the original point and click interface

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

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