Post reply

Integeration services

  • June 7, 2012 at 11:59 pm

    #257301

    HI,

    We are uploading the faltfile data to table and we are facing issue while performing.

    I am having 5 columns in the faltfile and

    i am view the all the data present in the flatfile as one column in flat file connection mannager

    for example:

    IN Flat File: Contain data as below.:

    TNCI3523 TNEYDO@ticccom TOBY NEYDORFF MUDAILY001 @

    IN Flat File CONNction Mannager:

    a).faltfile conection Manager Editor-----General---preview---

    All the data present the faltfile is displaying only in col5 and remaining all col as empty

    col1(empty) col2(empty) col3(empty) col4(empty) col5(TNCI3523 TNEYDO@ticccom TOBY NEYDORFF MUDAILY001 @}

    IN Table we have below columns:

    col1(Int) col2(varchar) col3(varchar) col4(char) col5(char) col6(varchar)

    My doute is there any corruption in my flat file or any difference in the flat file formt.

    as per my knowlege it show be displayed as a columns...in prevew..

    can any one plz help me....

  • June 8, 2012 at 12:20 am

    #1498501

    What is the delimiter of the flat file?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 8, 2012 at 12:34 am

    #1498505

    Thanks for reply:

    ON general tab:

    code page:1252(ANSI-LAtin I)

    Format :RAgged right

    header row delimiter :{CR}-{LF}

    Note: when seleted columns tab i am getting a pop widow with message

    INput column are ignored because they contains zeroes and negative values

    afert click Ok

    on Columns:

    font sim sum

    row delimeter :{CR}-{LF}

    Thanks...

  • June 8, 2012 at 12:37 am

    #1498507

    Ragged right. So you defined the length for each column?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 8, 2012 at 12:46 am

    #1498509

    Thanks for reply,

    yes am using RAgged right

    but i did not defined the length for each column.do i need to specify it any where.

    could you Please let me know...

  • June 8, 2012 at 12:56 am

    #1498512

    Ragged right is essentially fixed column width with no specific length for the last column.

    So you need to specify the length for each column with the markers.

    http://msdn.microsoft.com/en-us/library/ms180239.aspx

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 8, 2012 at 1:24 am

    #1498522

    Thanks

    Lenth has been specifed but still it is showing as

    i said before.

  • June 8, 2012 at 1:29 am

    #1498524

    Do you have spaces at the beginning of the line?

    You must have done something wrong in the configuration, because when you define the lengths, you do this on the preview of the actual data.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • June 8, 2012 at 5:21 am

    #1498649

    Thanks reply,

    I had specified the length for each column and now it showing correctly.

    But running the package it not uploading the data to table.Bit package executed successfully.

    can you plz suggest

  • June 8, 2012 at 5:23 am

    #1498652

    If you do a preview in the flat file source, does the data look OK?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 10 posts - 1 through 9 (of 9 total)

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