"Charles Kangai" <CharlesKangai@discussions.microsoft.com> wrote in message
news:CDD4FAF8-F3E7-492B-9973-D773E6220431@microsoft.com...
> You can use ODBC. Right-click in the Connection Managers tray and choose
> New
> Connection... Click on ODBC, then Add. Click New. In the data sources
> drop-down you should see an entry for dBase Files.

>> I need to import into SQL dbf files. In SQL2KDTS there was an option for
>> this, but in SSIS I do not see an option for dbf files. ......

"Cindy Winegarden" wrote:

> Hi Charles,
>
> For the record, not all DBFs are compatible with the dBase driver. FoxPro
> DBFs created with VFP3-6 may be accessed via the FoxPro and Visual FoxPro
> ODBC drivers, downloadable from
> msdn.microsoft.com/vfoxpro/downloads/updates/odbc, and also DBFs that are
> created with VFP7-9 if they don't use any of the new data features added in
> VFP7 and above.
>
> All versions of FoxPro DBFs are accessible via the FoxPro and Visual FoxPro
> OLE DB data provider, downloadable from
> msdn.microsoft.com/vfoxpro/downloads/updates .
>
> --
> Cindy Winegarden MCSD, Microsoft Most Valuable Professional
> cindy@cindywinegarden.com
>
>
> "Charles Kangai" <CharlesKangai@discussions.microsoft.com> wrote in message
> news:CDD4FAF8-F3E7-492B-9973-D773E6220431@microsoft.com...
> > You can use ODBC. Right-click in the Connection Managers tray and choose
> > New
> > Connection... Click on ODBC, then Add. Click New. In the data sources
> > drop-down you should see an entry for dBase Files.
>
> >> I need to import into SQL dbf files. In SQL2KDTS there was an option for
> >> this, but in SSIS I do not see an option for dbf files. ......
>
>