By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,070 Members | 1,238 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,070 IT Pros & Developers. It's quick & easy.

Import multiple .DBF files w/SSIS - OLE DB

P: n/a
Hi all,

New to SQL Server - trying to create an SSIS package that will look for
and import a series of Visual Foxpro tables (.DBFs) when they appear in
a folder.

The tables are/can be all different fields, field widths, etc. With
quite a bit of overlap though.

The end result should be table "ABC.DBF" is pulled into SQL Server as
table "ABC"

Using: SQL Server 2005 Enterprise, SSIS, *latest* version of VFPOLEDB
downloaded from MS

I have set up a package and tested it with several different tables and
it works great - but I have to redo the data source and destination
each time...

I need to get this to be a somewhat automated process, pulling in all
..DBFs no matter what they contain.

Can I do this with SSIS alone (and variable substitution) or do I need
to write a bunch of code...

Thanks very much for your time and thoughts...

Dec 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
A far quicker way of importing data is with BCP or Bulk Insert. SSIS
adds alot of overhead and time to import files.

On Dec 5, 5:27 pm, "SQLNewbie" <SQLNew...@gmail.comwrote:
Hi all,

New to SQL Server - trying to create an SSIS package that will look for
and import a series of Visual Foxpro tables (.DBFs) when they appear in
a folder.

The tables are/can be all different fields, field widths, etc. With
quite a bit of overlap though.

The end result should be table "ABC.DBF" is pulled into SQL Server as
table "ABC"

Using: SQL Server 2005 Enterprise, SSIS, *latest* version of VFPOLEDB
downloaded from MS

I have set up a package and tested it with several different tables and
it works great - but I have to redo the data source and destination
each time...

I need to get this to be a somewhat automated process, pulling in all
.DBFs no matter what they contain.

Can I do this with SSIS alone (and variable substitution) or do I need
to write a bunch of code...

Thanks very much for your time and thoughts...
Dec 7 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.