Groups > comp.databases.ms-sqlserver > #1752

Re: load multiple txt files to sql server

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!us.feeder.erje.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: load multiple txt files to sql server
Date	Sat, 24 May 2014 09:45:59 +0200
Organization	Erland Sommarskog
Lines	23
Message-ID	<XnsA3376359BB035Yazorman@127.0.0.1> (permalink)
References	<a76c710f-76e8-4cfd-b098-9f0d3a2e5897@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx05.eternal-september.org; posting-host="0c412830dbc354c08130c47cfccdbc83"; logging-data="20795"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18b7ZxhBZykJWgfBO44KnTM"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:7BlwHc6kj6TLoyuO2h0ZQaQK7gE=
Xref	csiph.com comp.databases.ms-sqlserver:1752

Show key headers only | View raw

tad na (teddybubu@gmail.com) writes:
> I need to import hundreds of data txt files to sql server 2008.
> All the txt files are in folders.  The folders names are country names.
> Obviously, I don't want to do this manually.
> This is what I want:
> 
> 1. import all country/folder names into sql server and create a table 
>      example: dbo.China
> 2. import all txt files in country/folder to specific dbo in sql server
> 
> Is this possible to do and is it done with stored procedures??
> How do I do this?  I am a beginner so any help is appreciated.

Is the structure of the text files the one and the same? In such case you 
should not create a table per file or folder, but a single table. The 
folder/country name should probably be a column in that table.

As for organising the import, you would have to write a program or use
SQL Server Integration Services (which I am not familiar with myself).

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

load multiple txt files to sql server tad na <teddybubu@gmail.com> - 2014-05-23 19:42 -0700
  Re: load multiple txt files to sql server Erland Sommarskog <esquel@sommarskog.se> - 2014-05-24 09:45 +0200
    Re: load multiple txt files to sql server bradbury9 <ray.bradbury9@gmail.com> - 2014-05-24 04:20 -0700
      Re: load multiple txt files to sql server tad na <teddybubu@gmail.com> - 2014-05-24 09:32 -0700
        Re: load multiple txt files to sql server Erland Sommarskog <esquel@sommarskog.se> - 2014-05-24 21:57 +0200
          Re: load multiple txt files to sql server bradbury9 <ray.bradbury9@gmail.com> - 2014-05-25 03:21 -0700
      Re: load multiple txt files to sql server rja.carnegie@gmail.com - 2014-05-24 15:30 -0700
        Re: load multiple txt files to sql server tad na <teddybubu@gmail.com> - 2014-05-24 20:50 -0700
        Re: load multiple txt files to sql server Erland Sommarskog <esquel@sommarskog.se> - 2014-05-25 11:16 +0200

csiph-web