Remove space in line feed

  • Hi,

    I have flat file, derived column and OLE DB in my Data flow task. It executed successfully. But when i see the data in my table there are some spaces in one of my last column. For ex

    1,Name1,End of shift [See space after End of shift]

    2.Name2,Break [See space after Break]

    I use TRIM function in my derived column. Even after that i won't affect. Still the spaces are there in my table.

    Here my question is, how can i trim the spaces in the last column of the text file?

    ---

  • What is the data type of the destination column?

    Can you be a bit clearer with your example? Are you saying that

    'End of shift'

    is being saved as

    'End of shift '

    ?

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Its varchar data type.

    There are the spaces in the flat file itself. I need to remove the space while inserting into the table. Usually, the text files are generated by reporting person.

  • "...spaces in the flat file itself..." I do not understand exactly what you mean. You did not answer my question about 'End of Shift'. Please provide accurate sample data.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Double click on file connetion manager. click on columns.

    Check the row delimiter = {CR}{LF}

    and column delimiter = Comma(,) --- Looks like already exists.

    Also check the field in General tab.

    If didnt work then re-create the file. 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

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