468,113 Members | 2,151 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,113 developers. It's quick & easy.

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 8760
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
3 posts views Thread by didacticone | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.