Im trying to import ALL my data from a csv file into my sql table by using the sql server 2008 r2 but I keep getting these errors any idea what they mean?
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data
conversion for column "p_termdate" returned status value 2 and status text
"The value could not be converted because of a potential loss of data.".
(SQL Server Import and Export Wizard)
Error 0xc0209029: Data Flow Task 1: SSIS Error Code
DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "output column "p_termdate" (634)"
failed because error code 0xC0209084 occurred, and the error row disposition
on "output column "p_termdate" (634)" specifies failure on error. An error
occurred on the specified object of the specified component. There may be
error messages posted before this with more information about the failure.
(SQL Server Import and Export Wizard)
Error 0xc0202092: Data Flow Task 1: An error occurred while processing file
"C:\Sonichr\hrpersnl.txt" on data row 882.
(SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
The PrimeOutput method on component "Source - hrpersnl_txt" (1) returned
error code 0xC0202092. The component returned a failure code when the
pipeline engine called PrimeOutput(). The meaning of the failure code is
defined by the component, but the error is fatal and the pipeline stopped
executing. There may be error messages posted before this with more
information about the failure.
(SQL Server Import and Export Wizard)
User contributions licensed under CC BY-SA 3.0