SSIS Lookup Transformation

My Learning: Log in Learning Report [Log in]

Remove Ads or Log in

Remove Ads or Log in

[+2]  |   [-0]

Remove Ads or Log in

We need you!

By becoming a proud member we can:
  • Switch off annoying ads
  • Create more articles and videos
  • Develop more useful features supporting your learning
  • Provide FREE webinars (for members)
  • Feel our hard work since 2011 is appreciated
Become a proud member and get exclusive features.

If 2% of our 64,943 visitors (Last 30 days) become a proud member than we can quit our jobs and work full time on this website. We started membership in May 2014 and so far 0.07% of our visitors are members and we would like to say THANK YOU to those who become a proud member and support our efforts.

Thanks to members:
  • Education is for FREE and we create more FREE articles and videos
  • We provide new features (members) that can speed up learning.
  • 53% of our page views (82,000 each month) do not have page ads.
  • We switched video ads from 14% of our videos (50 out of 345).
We have invested 4 years of our time in this website and we estimate it will take about 5 years before we can quit our jobs and dedicate all our time to develop considerably our website which should help to truly achieve our vision of free education for everyone; all thanks to support of our members only. Become a proud member

Visitor Voting

Do you find our website helpful?
Visitor Voting: Yes +70  |  No -1
Add comment (no email required).

Add Comment
Name: Stephen
Date Posted: 6/9/2014 8:38:39 PM
Comment: This is very helpful. I was wondering if you have to get a min record date from the flat file and put the result in the "Use results of an SQL Query" from the Lookup Transformation Editor in the Where clause. I would actually prefer to use all the date values found in the flat file and put it in a string that I search for record dates in the where. this way I do not have to go beyond the dates searched than what it is in the flat file. I was thinking of creating a variable that the minimum record date is then passed into the SQL query of the Lookup Transformation Editor. Thoughts or suggestions?

Are you a member?

If yes than please log in

Learning Map is for members with Bronze, Silver and Gold Membership.
For more information visit membership options.

Close this window , log in or learn more about membership benefits
  Become a Proud Member