Reading excel data in SSIS Script task RRS feed

  • Question

  • I am reading an excel file using OleDbDataReader.

    I can read all cells from the sheet. But when I read a string value its returning me a NULL value. If I replace that cell with a Integer value I can get it.

    Basically I am doing a validation on the cells to see if there are any non-numeric values. For certain cells which has string value I can get it as string and I can do the validation but for certain others I cant. Its returning as NULL. Any help would be really helpful.



    Wednesday, May 18, 2011 9:16 PM

All replies

  • Hi Tiffosi,

    This forum is about Windows Workflow Fundation. Let me move the thread to correct forum which should be more appropriate for you to get suggsetions.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, May 23, 2011 9:41 AM
  • FYI, the SSIS forum might be a better place to move the question:


    Paul ~~~~ Microsoft MVP (Visual Basic)
    Monday, May 23, 2011 5:31 PM