April 2, 2004 at 9:03 am
Hello,
>I have a text file that contains names and races. The
names are text values but the races are number values. A
lookup table has the race number in column 1 and the text
equivalent in column2. Right now I have set up a bulk
insert in DTS to import all of this information into a
table, but I'd like to insert the race text equivalent of
the number value instead of the number in the race
column. Is there an easy way to do this or a web resource
that describes how to acomplish this?
>Thank You,
>Chieko
April 5, 2004 at 8:00 am
This was removed by the editor as SPAM
April 5, 2004 at 12:15 pm
1.You could use a Transform Data task with lookup instead of the Bulk Insert task.
2. You could Bulk Insert into a work table then use an SQL task to join it with the lookup table and insert into your final table.
Greg
April 6, 2004 at 7:14 am
Greg,
Thanks so much for your suggestions. I don't know very much about DTS, so, can you recommend a resource where can I learn about Lookups and DTS?
Chieko
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply