none
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.

    • Edited by Murali dhar Sunday, February 17, 2013 6:49 AM
    • Edited by SSISJoostModerator Sunday, February 17, 2013 10:31 AM images not showing due incorrect html
    Sunday, February 17, 2013 6:46 AM

Answers

  • 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).

    • Marked as answer by Murali dhar Monday, February 18, 2013 12:14 AM
    Monday, February 18, 2013 12:06 AM

All replies

  • 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

    Sunday, February 17, 2013 10:33 AM
    Moderator
  • 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.

    Sunday, February 17, 2013 8:37 PM
  • Thanks for your reply. How to create hash value.

    Thanks in advance.

    Sunday, February 17, 2013 11:49 PM
  • 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).

    • Marked as answer by Murali dhar Monday, February 18, 2013 12:14 AM
    Monday, February 18, 2013 12:06 AM