|
Home > Archive > MS SQL Server > December 2006 > Import multiple .DBF files w/SSIS - OLE DB
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Import multiple .DBF files w/SSIS - OLE DB
|
|
| SQLNewbie 2006-12-05, 7:12 pm |
| 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...
| |
| John Bell 2006-12-06, 5:16 am |
| Hi
The connection string can be set with the expression editor see
http://www.sqlis.com/default.aspx?55
John
"SQLNewbie" 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...
>
>
|
|
|
|
|