RE: Update a column in a table from a flat file

Why not create a DTS package then? That's the standard way to import
data into SQL Server. Otherwise, you can go into SQL Enterprise Manager
and select Import Data on the table.

One time, I'd import data. Ongoing/repetitive, use DTS.

Loyd Goodbar
Senior programmer/analyst
BorgWarner
TS Water Valley
662-473-5713

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John McKee
Sent: Wednesday, February 13, 2008 13:50
To: Midrange Systems Technical Discussion
Subject: RE: Update a column in a table from a flat file

The table I am needing to update resides on an MS-SQL server. It is
named
FACILITY_PATIENT.

The file exported by Crystal Report Writer is a text file. No index,
and
unknown to MS-SQL. I refer to it as a "flat file" as that is the
database
language I was trained to use when referring to a non-keyed,
non-database file.
It is just plain text. FACILITY_PATIENT is an SQL table which reside on
an
MS-SQL server.

This is not relevant to System i, but I thought there was enough common
with
System i SQL and MS-SQL that i could get these updates performed.

John McKee