Posted by db55 on 12/07/06 14:42

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.com> wrote:
> 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...

[Back to original message]