I have a text file I want to import, it has a column containing a name
of a room. Now I want to import it but I want the ID of that room to
be inserted and not the name. So I create a transform data task for
the textfile to the table and try to define a lookup.

I do:

select RO_ID from rooms where RO_Name = Col007

This doesn't work, how do I reference the columns of the text file?


Thanks in advance,

Stijn Verrept.

So your text file is the source and what is the lookup source?

Have a look at this

How to Use Lookups in DTS
(http://www.sqldts.com/default.aspx?277)


"Stijn Verrept" <stjin (AT) entrysoft (DOT) com> wrote

Allan Mitchell wrote:

Thanks for the reply. The lookup source is a table in the sql
database. I checked the link you gave me, when I want to use lookup do
I need to use ActiveX?

Found it thanks! The link got me on the way .