Post reply

i want expected data

  • January 11, 2009 at 12:56 am

    #129049

    hi ssis Experts

    I have a problem in ssis

    My source is Flat file like:

    account no firstname lastname address1 address2 address3

    101 rajendra vishwesh 33

    101 rajedra vishwesh tambaram

    101 rajedra vishwesh US

    In the Above flatfile 3 rows

    I want OutPut Only single row like :

    account no firstname lastname address1 address2 address3

    101 rajendra Vishwesh 33 tambaram US

    which transformation needful and how to use, please Explain

    Thanks

  • January 11, 2009 at 1:10 am

    #924959

    I suggest that you bring all of the data into a SQL Server staging table and then run one or more 'clean-up' queries on the staging table to do the processing that you require.

    Doing this on the source data as it is imported is not at all easy.

    The clean-up queries will be quite difficult. For example, how would the system know to keep 'rajendra' and discard 'rajedra'?

    I am assuming that Account No is the 'Unique' identifier for the data?

    Phil

  • January 11, 2009 at 11:21 am

    #925022

    I like Phil's suggestion and that's what I go with. It could get complicated to try and merge these rows using SSIS.

  • January 13, 2009 at 2:45 am

    #925723

    If you enjoyed answering this question, you can do it all over again here:

    http://www.sqlservercentral.com/Forums/Topic634483-148-1.aspx

    Phil

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

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