could not find installable isam

• sqlstud

  SSCrazy

  Points: 2527

  More actions

  September 4, 2012 at 12:16 am

  #393084

  Hi,

  I am using SSIS 2005.

  Got the source file in XLSX format.

  As 2007 format not supported in SSIS 2005, so i have installed related drivers and created OLEDB connection. Changed the connection propeties as

  Data Source=c:\sample.xlsx;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0;

  it is working fine.

  Got the source file in XLSB format.

  Followed the same steps. But got the error as " could not find installable isam"

  Tried to change the connection properties as

  Data Source=C;\sample1.xlsb;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0;HDR=IMEX=1;

  But got the same error

  Please let me know the solution

  Regards

  SQlStud