none
Difference between SSIS 2005 & 2008 in Excel Source

    Question

  • Hi,

    I just got a question asking me if there is any difference in using Excel source in SSIS 2005 & 2008? Let me know if you are aware of this.


    My Blog    |      Ask Me     
    Monday, September 26, 2011 7:44 AM

Answers

  • Yes, there's difference in Excel source in SSIS 2005 & 2008 versions.

    - In 2005 you can only make a connection to XLS file & cannot make a connection to a XLSX (ver 2007) file. Instead you'll have to make a OLEDB Source connection by providing the Excel 2007 connection provider.

    - In 2008 you can make a connection to both XLS & XLSX files.


    ~manoj | email: http://scr.im/m22g
    http://sqlwithmanoj.wordpress.com
    MCCA 2011
    • Proposed as answer by Koen VerbeeckMVP Monday, September 26, 2011 9:46 AM
    • Marked as answer by Sudeep Raj Monday, September 26, 2011 11:35 AM
    Monday, September 26, 2011 8:25 AM