Reading DBase III/IV file with MS SSIS

• WilburSmith

  SSCrazy

  Points: 2896

  More actions

  September 22, 2011 at 4:47 am

  #257657

  Hi,

  Haven't read DBase files before with SSIS and need help

  I managed to create OleDB connection (Microsoft Jet 4.0....) in Connection Manager. The 'Test connection' succeeds with either 'dBASE IV' or 'dBASE III' written in 'Extended properties' but when I try to implemet the OleDB Source in the package, I get:

  'Error opening rowset for "dbasefilename"'

  What should I do?

  V

• WilburSmith

  SSCrazy

  Points: 2896

  More actions

  September 22, 2011 at 11:53 am

  #1385359

  FYI

  The name of the DBF file must be of old dos 8.3 format....

  v