|
|
Posted by SQLNewbie on 12/06/06 00:27
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...
Navigation:
[Reply to this message]
|