I am facing one problem with sql 2005 SSIS while uploading a "||" seperated text file with Data FlowÃÂ in SSIS.Below I am giving the sample data of the text file
data||data||dataÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ
When I uploaded it using sql 2000 DTS it wasÃÂ not giving and it was being uploaded into the tableÃÂ but when I tried with SQL 2005 it is giving the below problem.
"[Flat File Source ] Error: Data conversion failed. The data conversion for column "Column 2" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". "
View Complete Post