Cannot map the lookup column, 'ID', because the column data type is a binary large object block (BLOB) SSIS

Comments (1) | Share

Cannot map the lookup column, 'ID', because the column data type is a binary large object block (BLOB)

There is a possibility that you might get this error while working in SSIS and trying to do a lookup to a csv file.

In this case your destination columns might be of type (BLOB) - Long Text / Ntext and you might face this error

And I tried a lot to convert the data inside the lookup column to varchar but it was constantly throwing an error :

I tried :

• select cast(ID as varchar) as ID from table1
• select convert(varchar(50),ID) as ID from table1

But the above statements dint work. So was googling for quite some time and got the answer :

The following query worked finally :-

select cstr(ID) as ID from table1

Reference :-

Convert Microsoft Access (JET SQL) to SQL Server (T-SQL) Cheatsheet