Home > SSIS > Case Sensitive Lookup Task – SSIS

Case Sensitive Lookup Task – SSIS


You may have come across this situation while using Lookup task in SSIS. Case sensitive data comparison. There is no property to set the case-insensitive string comparison in lookup task. So,  We usually convert the source and the lookup data to a unique case and compare it.

I was also doing the same thing for a while and I found a simple solution that actually helped me to avoid intermediate string conversion unique case for lookup.

Solution is in the Cache mode option in the general tab of lookup task that is Full Cache, Partial Cache and No Cache.

If you use Partial Cache or No Cache then the Lookup task compares the string with case-insensitive option.

it is a cool stuff to know. But, there is a trade-off in using cache lookup or non cache lookup. You are the right person to make a decision on your side.

Thanks for reading.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: