ragged right file data not coming correctly

  • hi

    i have flat file where all data coming correctly except some 2.

    where to look into ssis package

  • Very informative thread there. I'd say you probably need to look at your flat file connection manager to see what's going on. As for any specific errors, you don't mention any so it's hard to tell. Good luck.


    I'm on LinkedIn

  • Inside of it. Based on what you gave us, that's the best I can do right now.

  • i am not able to paste screen shot here.

    here is example of my file

    1 krut galaxy

    2 rtgh erfg

    3 rfgg efgh

    here , 2 and 3 records should be in line of records 1, 1 space is coming ahead.

    i see my flat file connection manager ,

    for record 2 and 3 , in column section, rtgh and erfg coming together. for record 1 , krut then there is line

    and then galaxy.

    but for all other records its coming correctly

  • Seems as if you probably have the row and column delimiters set incorrectly for that file. Have a look at the file in a text editor that allows you to see the invisible characters and verify that you have the correct settings in the flat file connection manager.


    I'm on LinkedIn

  • When you 'preview' from the datasource, does it look correct? If not, do you have embedded carriage returns or some other control chars in the source that might be causing a line split where you are not expecting it?

  • but its coming correctly for all the records except 2.

    my stored proc return it correctly

  • coool_sweet (4/8/2015)


    but its coming correctly for all the records except 2.

    my stored proc return it correctly

    Before simply dismissing what has been suggested, at least try it out. What's so difficult about opening up a text file and examining it for carriage returns, tabs etc.???


    I'm on LinkedIn

  • look at your source file in notepad++ or its ilk and turn on visible control characters.

  • ok

    i did see my file in notepad++.

    for the correct records there is LF at the end of last column.

    for the record which are not coming properly they have LF in middle and also at the end of the last column.

    i think LF should not come in the middle ,it should only come at the end of the last record.

    how to remove it from ssis/stored proc?

  • even if i remove LF from the middle its not coming correctly.

    a bv 0923 e

    b dfg 0456 e

    c efg 3456 e

    here b and c are not coming in proper way

  • If the source file is bad, make whoever sent it to you fix it.

  • there is no source file

    my data is coming from stored proc and i am creating flat file

  • Well you know where the problem is then. If its your code creating the file and you haven't accounted for malformed rows due to embedded control data, then fix that code, which will fix your file and your import package will work then.

Viewing 15 posts - 1 through 15 (of 25 total)

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