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

Please remember, that SSIS "out of the box" don't support CSV files (i.e. embedded quotes, SQL Server 2012 is supposed to support it). Could you post data types defined in the flat file connection manager and 4th row from source data?
November 4th, 2011 1:11am

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.
Free Windows Admin Tool Kit Click here and download it now
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
November 4th, 2011 3:33am

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.
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2011 9:48am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics