Import multiple .DBF files w/SSIS - OLE DB

[SQLNewbie]

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...

[db55]

Re: Import multiple .DBF files w/SSIS - OLE DB

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...@gmai l.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...