"Text was truncated or one or more characters had no match in the target code page." (SQL Server Import and Export Wizard)

SQL Server'a excelden tabloya import yapmaya çalışırken hedef tabloda veri tipleri büyüklüğünü ayarlamanıza rağmen aşağıdaki hataları alıyorsanız, girdi kısmında ilgili verinin tipini DT_STR den DT_TEXT ye çekmeniz gerekli

"Text was truncated or one or more characters had no match in the target code page.". (SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source.csv"  returned error code 0xC0202092

detaylar burada