471,065 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,065 software developers and data experts.

Import multiple .DBF files w/SSIS - OLE DB

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

Similar topics

1 post views Thread by Chicagoboy27 | last post: by
2 posts views Thread by mattc66 via SQLMonster.com | last post: by
1 post views Thread by Eric | last post: by
2 posts views Thread by othellomy | last post: by
reply views Thread by hoots | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.