I have a csv file which I am processing through SSIS. But there are companies in the list which have some produce data and the length of those values are more than 4000 bytes which is causing this job to fail. When I change the Commodity data type to text, then the solution file complains about the conversion from unicode to non-unicode. Any idea what to do here?
CREATE TABLE [dbo].[Commodity](
[CompanyNids] [nvarchar](50) NULL,
[Commodity)] [nvarchar](MAX) NULL
) ON [PRIMARY]