X-Received: by 10.66.148.10 with SMTP id to10mr5448025pab.12.1400949173089; Sat, 24 May 2014 09:32:53 -0700 (PDT)
X-Received: by 10.182.111.229 with SMTP id il5mr46204obb.11.1400949172943; Sat, 24 May 2014 09:32:52 -0700 (PDT)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!c1no16038905igq.0!news-out.google.com!qf4ni12380igc.0!nntp.google.com!c1no16038898igq.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-sqlserver
Date: Sat, 24 May 2014 09:32:52 -0700 (PDT)
In-Reply-To: <fbb48642-a3cf-4bc8-a7c0-f00722965b80@googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=162.219.230.229; posting-account=1BSfbAoAAADPEPNpYGSQDee4_67fTiEa
NNTP-Posting-Host: 162.219.230.229
References: <a76c710f-76e8-4cfd-b098-9f0d3a2e5897@googlegroups.com> <XnsA3376359BB035Yazorman@127.0.0.1> <fbb48642-a3cf-4bc8-a7c0-f00722965b80@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <25f5fd22-e8a7-4a0e-964e-f9a7652e04c6@googlegroups.com>
Subject: Re: load multiple txt files to sql server
From: tad na <teddybubu@gmail.com>
Injection-Date: Sat, 24 May 2014 16:32:52 +0000
Content-Type: text/plain; charset=ISO-8859-1
Xref: csiph.com comp.databases.ms-sqlserver:1754

All txt files have the same column structure so that is a big relief.
I like the idea of creating one table but the problem is each txt file does not have a column with the country name.  How can I insert a new column with the country name when importing to sql server?