Setting: SQL 2K
Input file: text file, multi-column, fixed length fields, some greater
than 15 chars
Output file: text file, where all columns are less than 15 chars
(serves as input for an "old" program that noone can modify.)
I want to read a record from Input file and decide which Sql Table to
send it to: TblGood or TblRejects. TblGood has records with fields < 15
chars; TblRejects has records where one of the fields is >=15 chars.
I don't know how to use DTS to direct a record to one table or another.
TIA,
Bill Salkin