Errors importing cvs file
Hi,
I have a .csv file(1GB) that need to be imported. I have search a lot but i cant solve. Here is the report:
- Executing (Error)
Messages
* Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data conversion for column "Facility Name" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)
* Error 0xc020902a: Data Flow Task 1: The "output column "Facility Name" (18)" failed because truncation occurred, and the truncation row disposition on "output column "Facility Name" (18)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)
* Error 0xc0202092: Data Flow Task 1: An error occurred while processing file "C:\Users\Zafer\Desktop\imp\file.csv" on data row 4.
(SQL Server Import and Export Wizard)
* Error 0xc0047038: Data Flow Task 1: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - file_csv" (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)
November 3rd, 2011 10:29pm
The flat file metadata and sql table metadata are not matching for Facility Name column.Check for the 4th row in the flat file for the discrepency.Rakesh M J | MCTS,MCITP ( SQL SERVER 2008 )
Dont forget to mark it as Answered if found useful |
myspeakonbi
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2011 1:00am
Hi
Go to Advanced and verify outputColumn width and match with your table datatype / the size of data you have it on file
make it sure you do not want to ignore the data just becasue of some errors .
Alos use below links for more informations
http://social.msdn.microsoft.com/forums/en-us/sqlintegrationservices/thread/00E2E864-A4FE-469C-B2C4-844804BBA8EE
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/b901f8f5-79bb-40fc-939a-e11b085c3cf3
Suhas | MCP | MCTSMark as Answer if this resolves your problem or "Vote as Helpful" if you find it helpful.
November 4th, 2011 2:58am
after implementing the solution given by Suhas, if you still get error then use data conversion task to format the column size of the source to respective size in the destination
** column metadata size should not be less than the data available
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2011 3:33am