Lookups on string columns failing

#1

(Note: SSIS not DTS)

Anytime I try to perform lookups for string columns, I never get a match
unless the string takes up the maximum size. For example:

Pipeline Value Lookup Value Result
========= ========= =====
THIS WORKS THIS WORKS Finds lookup value
NOPE NOPE Does NOT find lookup value

The database string is declared as varchar(whatever) and the pipeline is
declared as DT_STR(whatever), where "whatever" is an equal value length for
the strings. I am trimming all string data as it is loaded from the flat
files into the pipeline. Is this causing the problem?

Thanks!

Brandon

#2

This was answered in a blog I ran across totally by accident.....
http://blogs.conchango.com/kristianw...2/22/2955.aspx

Thanks a ton, I wasted soooooo much time on this problem.

Brandon

#3

This is a good article. I am new to SSIS too and spent fair amount of time
figuring the lookup issue on my own

"Brandon Lilly" wrote:

Quote:

(Note: SSIS not DTS)

Anytime I try to perform lookups for string columns, I never get a match
unless the string takes up the maximum size. For example:

Pipeline Value Lookup Value Result
========= ========= =====
THIS WORKS THIS WORKS Finds lookup value
NOPE NOPE Does NOT find lookup value

The database string is declared as varchar(whatever) and the pipeline is
declared as DT_STR(whatever), where "whatever" is an equal value length for
the strings. I am trimming all string data as it is loaded from the flat
files into the pipeline. Is this causing the problem?

Thanks!

Brandon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Lookups on string columns failing

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Lookups on string columns failing - 04-26-2006 , 04:39 PM

RE: Lookups on string columns failing - 05-04-2006 , 05:44 PM

RE: Lookups on string columns failing - 05-21-2006 , 07:08 PM