Having confusion in my scd developing package RRS feed

  • Question

  • Hi all,

     Good Morning to all,

    I need a help that i am having a excel sheet with 18 columns in that column one field named as GUID it will be duplicates for the locations in the same states.... I need to maintain that 18 columns in two tables based on which column i need to split i am having a little bit of confusion. Please any one help me(From that tables i need to maintain the history for that records coming from the sheet anyone give me the suggestions that which transformation is best for the requirement). 

    I am expecting that i need to add the additional column for the both tables but how can i split i am not getting the correct output.

    Plz anyone help me ASAP


    Azarudhin S

    Sunday, April 21, 2013 3:11 AM


  • Hi Azarudhin,

    Can you give me the expression, the data and output that you are using to split it will be easier to debug?

    Generally, if you trying to split strings or create new column, use derived column task in the Data Flow Task.

    Hope this helps!



    • Marked as answer by Eileen Zhao Friday, April 26, 2013 2:31 AM
    Sunday, April 21, 2013 11:33 PM