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]
If you changed the input data type of an existing input column in your source, make sure you manually change the data type for the corresponding output column in the source as well. That doesn't happen automatically and often leads to data type conversion errors.