HI


I'm trying to create an SSIS package using the SQL Server Import and Export wizard

I'm importing s csv file and am getting this error

Data conversion failed while converting column "Address 1" (46) to column "Address 1" (187). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data
IU've set the address1 to be string [DT_STR] and a width of 250

Why would I be getting this error

Thanks

Nick