Re: Import many groups of dbase files

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 14:14:54 -0000

Probably the easiest way would be

1. Use a cmdline zip tool to extract the folder
2. Loop through the folder and move the right file into the right directory
3. Have 20 * DataPump tasks (1 for each folder)
4. Fire the package

You can use for the looping this article

Looping, Importing and Archiving
(http://www.sqldts.com/Default.aspx?246) 

-- 
----------------------------
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"kda" <anonymous@discussions.microsoft.com> wrote in message
news:AEC63B9D-4DB3-47C7-8DFF-2C8A6C107033@microsoft.com...
> I would great appreciate any suggestions on the following problem:
>
> Every day about 30 zips files will come in.  Each zip file contains a
folder with about 20 dbf files.  The dbf files are all named accordingly.
So I would like to take each zip file and import all of the dbf into
appropriate 20 sql tables.
>
> Question is how I should arrange the files to have a dts got through them
all.  I would like to keep them in folders according to the zip files, but
then each zip have 20 different named dbf files.   So then 30 times running
the dts with 20 different data pumps.
>
> Or should I extract the zip files according to the dbf, putting all the
same tables in one folder, incrementing the name.  And then have the dts go
through each folder and import all dbf into the same sql table and on to the
next folder.  So then have 20 dts packages to go through for each sql table.
>
> Any suggestions, examples?
>
>

Relevant Pages

  • Re: create dynamic file path for linking to text files in Access 2003
    ... that's enough to give you an idea of how to do it using dbf files. ... empty version of my MDB into a new folder along with that month's DBFs ... to the system folder as %SYSTEMROOT% or whatever. ...
    (microsoft.public.access.formscoding)
  • XML transfer to SQL table
    ... I have a folder with about 10.000 xml files that need to be transferred to a ... SQL table. ... How can I do this using dts? ...
    (microsoft.public.sqlserver.dts)
  • XML import to sql table
    ... I have a folder with about 10.000 xml files that need to be transferred to a ... SQL table. ... How can I do this using dts? ...
    (microsoft.public.sqlserver.xml)
  • ASP.NET and directory security
    ... I come from a win forms background, and am building a web site that needs to ... I have created a virtual directory on the same machine as where the DBF files ... My code to connect to the folder where the DBF files are located is basically ... connects to the Foxpro Database folder - also on my development machine - ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ASP.NET and directory security
    ... You have setup the DBF files on machine creating a shared directory and ... giving the MACHINE\ASPNET user access to that directory? ... My code to connect to the folder where the DBF files are located is ... What do I need to setup in terms of permissions to access a FOLDER on ...
    (microsoft.public.dotnet.framework.aspnet.security)