SSIS package converting varchar(MAX) to nvarchar(50)

[raghvendrapanda]

hy, I have created an ssis package which tranfers data from one database to another,first i drop the tables and then recreat it before inserting data. I have a cloumn which has a datatype of varchar(MAX) and on re creation becomes nvarchar(50). what should i do to avoid it. Thanks & Regards, Raghvendra Panda