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. I tried a few that I
thought MIGHT be the instance but nothing has worked so far. What file type
do I use for this now?

TIA

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.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk


"JC HARRIS" 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 (AT) cindywinegarden (DOT) com


"Charles Kangai" <CharlesKangai (AT) discussions (DOT) microsoft.com> wrote

Thanks Cindy - I have taken note.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email alias: charles
email domain: kangai.demon.co.uk

"Cindy Winegarden" wrote: