SQL Server Blogs

Voices from the UK SQL Server Community
Welcome to SQL Server Blogs Sign in | Help
in Search

Jorg Klein's Microsoft Business Intelligence Blog [Macaw]

SSIS – Lookup Transformation is case sensitive

Published Feb 12 2008, 04:34 PM by jorg
Filed under:

Comments

 

SSIS Junkie said:

Jorg Klein has just written a useful blog entry about the SSIS Lookup component entitled "SSIS – Lookup

February 12, 2008 5:14 PM
 

Dave said:

Really interesting blog Jorg! I'll certainly keep this in mind!

February 12, 2008 8:55 PM
 

Jack Corbett said:

I also ran into this problem and after reading this post and others I was able to solve my problem.  I went to the advanced tab and Checked Enable Memeory Restriction and Modify SQL Statement.  Mapped the parameter and I was fine.  It may still be hitting the DB once per lookup, but at least the lookup is working.  I had tried using Upper in both my Lookup Query and Source Query and I still encountered the problem.  Another "solution" I first used in this situation was to use a Fuzzy Lookup with a min similarity of 1 and I got the matches I needed.

March 4, 2008 6:36 PM
 

Douglas Laudenschlager said:

The SQL Server Integration Services team added valuable new caching options (and scalability) to the

January 19, 2009 10:10 PM
 

Tim Mitchell said:

Space Sensitivity in SSIS Lookups

September 29, 2009 2:02 PM
 

SSIS – Data Flow Transformations « Systems Engineering and RDBMS said:

Pingback from  SSIS – Data Flow Transformations « Systems Engineering and RDBMS

October 13, 2009 4:12 PM
 

TrackBack said:

November 18, 2009 9:29 PM
 

Dougbert's Blog said:

Learn more about Lookup and its new features: A compilation

March 24, 2012 5:29 PM
 

Space Sensitivity in SSIS Lookups « Tim Mitchell's SQL Server BI Blog said:

Pingback from  Space Sensitivity in SSIS Lookups « Tim Mitchell's SQL Server BI Blog

January 1, 2013 5:39 AM
 

Space Sensitivity in SSIS Lookups | Tim Mitchell said:

Pingback from  Space Sensitivity in SSIS Lookups | Tim Mitchell

January 1, 2013 8:33 PM
Powered by Community Server (Commercial Edition), by Telligent Systems