Post reply

Microsoft excel version

  • August 30, 2012 at 6:59 am

    #393054

    my excel file has xlsx version.

    and i am using visual studio 2005.

    it gives me error at excel source connection. what version do i need to choose.

  • August 31, 2012 at 12:07 am

    #1532224

    Either convert to 2003 Excel, .xls, or use the following method:

    Using Excel 2007 files as a Source in SSIS 2005[/url]

    Or upgrade to a recent version of SSIS, that's also an option.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

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