Post reply

Only one column not extracting from Excel source

  • March 17, 2013 at 2:41 pm

    #394408

    I am trying to extract the data out of an excel file with 3 columns Success, Failure and Waiting. The data from Success and Failure is getting extracted perfectly, but no data is being extracted from the excel file. The data types of source and destination are matching. I tried different file with the same structure..but still no data is being extracted from the Waiting column.

    Can anyone please help.

    Thank you!!

  • March 17, 2013 at 5:55 pm

    #1597934

    Help pls guys..

  • March 17, 2013 at 11:09 pm

    #1597960

    Hi rockstar283,

    Can you make sure mapping is done correctly?

    I am sure you might have done this, but still, wanted to recheck.

    Thanks,

    Satish Chandra

  • March 18, 2013 at 4:14 am

    #1597997

    Yup mapping is good..datatypes are good..checked the data in data viewer and see data for other columns but not for this column 🙁

  • March 18, 2013 at 4:26 am

    #1597998

    Does the Waiting column have mixed data types, some numeric, some text? You many be running into an issue where SSIS thinks the data should be one type and in reality it is not.

    Maybe check out:

    http://microsoft-ssis.blogspot.com/2011/06/mixed-data-types-in-excel-column.html

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

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