Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
padgettbrian
Starting Member
23 Posts |
 Posted - 2012-02-22 : 14:38:31
|
| Biztalk SSIS Import Wizard Succedes with a txt file containing 1,996 records but fails with the a txt file with any more records. The txt files have been generated numerous times and tried but always fails with the following messages...[Source - 6kRec_txt [1]] Error: Data conversion failed. The data conversion for column "Column 328" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". [Source - 6kRec_txt [1]] Error: The "output column "Column 328" (994)" failed because truncation occurred, and the truncation row disposition on "output column "Column 328" (994)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. [Source - 6kRec_txt [1]] Error: An error occurred while processing file "D:\SRVR4 Share\6kRec.txt" on data row 3624. [DTS.Pipeline] Error: The PrimeOutput method on component "Source - 6kRec_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. [DTS.Pipeline] Error: Thread "SourceThread0" has exited with error code 0xC0047038. [DTS.Pipeline] Error: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown. [DTS.Pipeline] Error: Thread "WorkThread0" has exited with error code 0xC0047039. |
|
|
padgettbrian
Starting Member
23 Posts |
Posted - 2012-02-22 : 14:56:56
|
| I can send you copies of the text files to see if it runs on your system, anything you need that could help ill provide. |
 |
|
|
dmooney
Starting Member
3 Posts |
Posted - 2012-02-27 : 09:07:13
|
| HI there Brian,Have you tried setting the error handling on the Source? If it's a flat file go to the error output from the left hand navigation pane on the component and configure the 'Truncation' column; set it to 'Ignore Failure' then give it another whirl.D Mooney |
|
|
|
|
|
|
Biztalk SSIS Import Wizard GOD PLEASE HELP!!!