Import Csv file into Sql Server 2008 R2 Error

-1

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)
ssis
sql-server-2008-r2
asked on Stack Overflow Jul 8, 2020 by Double00 • edited Jul 9, 2020 by Double00

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0