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:59:21
|
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...
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.
[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. |
|
|
|
|