Link to home
Start Free TrialLog in
Avatar of Saroj13
Saroj13

asked on

How to use Lookup transformation for Varchar(Max) columns in SSIS Package?

In SSIS Package doing incremental data loading, Lookup transformation is used for updating the data. Lookup columns is giving error for VARCHAR(MAX) column. Cannot map the Lookup column because the column data type is a BLOB. How to use lookup transformation for varchar(Max) column? I am not able to change the table field type as the column is having more than 12000 characters.

Please see the attached package image steps in the attachment
IMG_2109.jpg
IMG_2110.jpg
IMG_2112.jpg
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.