Post reply

Reading an Excel cell date value via an Execute SQL Task

  • May 7, 2015 at 8:21 am

    #307731

    Hi all,

    I need to read a specific cell value that is a date from an Excel file and write it to a user variable. I followed this link;

    http://sqlage.blogspot.co.uk/2013/11/ssis-read-excel-cell-value-in-ssis.html

    The task fails giving me this error --> An error occured while assigning a value to variable 'ExcelDate': Unsupported data type on result set binding 0.

    The variable 'ExcelDate' is a datetime type. I even changed this to a string and it still failed.

    It seems that the date is the issue, because when I put some text in the excel cell, and write it to a string variable in SSIS it works!

    Anyone have any idea how to fix this? Or, is there another workaround..

    Thanks! 🙂

  • May 7, 2015 at 8:32 am

    #1796250

    Try bringing it in as a decimal ... that is how Excel stores datetimes.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • May 8, 2015 at 2:52 am

    #1796483

    That didn't work I'm afraid. Same error 🙁

  • January 20, 2016 at 9:44 pm

    #1853356

    This thread comes up on Bing when searching for a way to capture the contents of a cell with a date in it and nowhere else I could find specifically solved it. I know this thread is a bit old but thought I would post a link to a solution nonetheless, in case it helps the OP or others finding this through a search engine:

    http://www.sqlservercentral.com/Forums/Topic1745924-364-2.aspx#bm1754373

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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