Error storing data in text file???

Last Post 29 May 2008 09:38 PM by jarrodr. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
jarrodr
New Member
New Member

--
27 May 2008 01:23 AM
The error I recieve is as follows:

"[Flat File Destination [13]] Error: Data conversion failed. The data conversion for column "SDATA" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". "
"[Flat File Destination [13]] Error: Cannot copy or convert flat file data for column "SDATA". "
"[DTS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Flat File Destination" (13) failed with error code 0xC02020A0. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. "
"[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC02020A0. There may be error messages posted before this with more information on why the thread has exited. "
"[DataReader Source [207]] Error: The component "DataReader Source" (207) was unable to process the data. "
"[DTS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "DataReader Source" (207) returned error code 0xC02090F5. 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. "
"[DTS.Pipeline] Error: SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited. "

I am selecting data from an OBDC then copying it to a text file an I always get this error, but when I change the destination to a excel file it works perfectly. But the whole point of the package is to copy to a text file.

Please could you help me, your replies will be greatly appreciated.
SQLUSA
New Member
New Member

--
27 May 2008 08:16 AM
The flat file destination defaults the columns to characters with length of 50. You can change this by going to the Advanced page of the Flat File connection page and set the length manually to the appropriate length.

Let us if this solution is working for you.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2008 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
jarrodr
New Member
New Member

--
27 May 2008 10:28 PM
quote:

Originally posted by: SQLUSA
The flat file destination defaults the columns to characters with length of 50. You can change this by going to the Advanced page of the Flat File connection page and set the length manually to the appropriate length.

Let us if this solution is working for you.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2008 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/


Hi Kalman (SQLUSA),

Its all set on length 200, which is the correct length but I still have the same problem...
The "OutputColumnWidth" and "InputColumnWidth" is 200
SQLUSA
New Member
New Member

--
28 May 2008 01:23 AM
How about data corruption? Is that a possibility?

The source & destination code pages are different?

Have you isolated the data which is causing it? NULL value in source?

How about configuring Error Output in the Data Flow component:

ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/extran9/html/53d7eeea-927d-4b45-8ea9-084e65ad5390.htm

Let us know what happens.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQL Server 2005 Training, SSAS, SSIS, SSRS: http://www.sqlusa.com/
jarrodr
New Member
New Member

--
29 May 2008 09:38 PM
Hi guys,

thanks for all your help, I increased the destination Column width from 200 to 250 and it works fine now... but gives warnings, but I think I can live with that.
You are not authorized to post a reply.

Acceptable Use Policy