none
Pulling dinstinct rows in SSIS from Excel

    Question

  • im getting multiple rows for each fld_Id column from Excel sheet

    i want to pull only one row for each of the fld_Id and keep in a master table.

    can some one give me any idea to acheive this using which transformation and how.

    Monday, May 06, 2013 9:49 PM

All replies

  • Hi VJReddy,

    In your Excel source use SQL Command--

    SELECT DISTINCT fld_Id
    FROM            [Sheet1$]

    Where Sheet1 is the name of your worksheet.

    Hope this helps.

    Thanks,
    Megha

    Monday, May 06, 2013 9:56 PM
  • Use Sort Data Flow Component inside Data Flow Task.

    2 things that you need to take care while setting "Sort Data Flow",

    a) Choose all fields except fld_id

    b) Check the box at the bottom to remove duplicates


    Regards, RSingh

    Tuesday, May 07, 2013 2:02 AM
  • Hi RSingh,

    As far as I can see data is getting pulled from Excel sheet, so your OLEDB source is useless. Besides if VJ is interested in only 1 column from excel sheet he might as well use a command..Wouldn't that be easier? unless I have completely missed out in understanding the question!

    Thanks,
    Megha

    Tuesday, May 07, 2013 4:12 AM