Error at Lookup Transformation Editor

Question

When i try to map input columns to output columns in the above look up transformation.I'm Getting the below error

Thanks in advance.

Answer 1

You cannot lookup blob columbs... Check the datatype of SSIS and of your lookup source query

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

If any of your columns is blob, verify if you can map it to simple data type in the source query or SSIS flow.

If not possible, try to create a hash value for the blob and use hash in the lookup.

Answer 3

Thanks for your reply. How to create hash value.

Thanks in advance.

Answer 4

TSQL native hash is limited to 8000 characters(http://msdn.microsoft.com/en-us/library/ms174415.aspx), so it is better to use .NET hash functions:

http://www.dotnetfunda.com/articles/article858-hash-algorithm-in-net.aspx

Be sure to take into account hash collision (with modern hash algorithms portability of collision is near zero).