SSIS 2008 using Lookup Transform, hitting a blob

Question

Error Message: Cannot map the lookup column, 'Name', because the column data type is a binary LOB.

I have an excel source with a string field call it 'Type' with a value of 'Pocket Guide'

I have a field in SQL Server 2008 call it 'Name' set up as a varchar(max) with a value of 'Pocket Guide'

I have a field in SQL Server 2008 call it 'Name Type' set up as integer with a value of '1'

I am using the Look up Transform to match 'Type' to 'Name' in order to retrieve the 'Name Type' - but I am running into the Blog error.

2 months new to SSIS - Will someone please provide a workaround or solution? - Thanks!

Answer 1

Go to advanced editor of the look up component and check the datatype of the column Name. Change it to dt_str if required.

---

Nitesh Rai- Please mark the post as answered if it answers your question

Answer 2

The 'Name' column is not part of the Input Columns in the Look up transform.  It is among the Available Lookup Columns.

In advanced editor, the 'Name' column is not in the 'input' tab for adjustment.

** database change **
Our workaround was to change the varchar(max) to varchar(25).
Now going from Input column to Lookup column works without error using the Lookup T.