My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/SSIS Lookup population
The new RSS feed is here
In SSIS the lookup component can only be loaded from a SQL statement this is a bit restrictive/annoying. What would be nice is to load from any source that SSIS can use, i.e. OLEBD, raw file, etc.
If you think the lookup should be bale to be populated from any source vote for Jamies suggestion here
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/SSIS Lookup population