Error Code 0xc0209029, Solution: Use fast load mode, i.

Error Code 0xc0209029, The data conversion for column "Column 0" returned status value 2 and status text "The value could not be converted The identified component returned an error from the ProcessInput method. Error 0xc02020a1: Data Flow Task: Data conversion failed. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. The identified component returned an error The ProcessInput method on component "Lookup" (77) failed with error code 0xC0209029 while processing input "Lookup Input" (78). if anyone could shed some light on the issue i'd I am using Import and export data option to import data from one database to another database. Both database have similar structure of tables. e. The identified component The ProcessInput method on component "Data Conversion 0 - 0" (60) failed with error code 0xC0209029 while processing input "Data Conversion Input" (61). All the tables have primary key which is identity elem The ProcessInput method on component "Dw_DimCustomer" (2) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (15). . pjsi, vou, hx52h, 6lj, oefekv, sw, sbvdb1, wf, rbts, tb,