Geeks With Blogs

Sathya Narayanan Srinivasan .NET Developer

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

 

 

 

Posted on Wednesday, June 23, 2010 4:16 PM | Back to top


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

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © sathya | Powered by: GeeksWithBlogs.net