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 |
|
Jarrodr
Starting Member
11 Posts |
 Posted - 2008-05-27 : 04:38:21
|
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. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-27 : 04:49:10
|
| whats the data type of SDATA column in your source? |
 |
|
|
tmitch
Yak Posting Veteran
60 Posts |
Posted - 2008-05-27 : 21:28:11
|
| Looks like either a data type or a data length error. Can you post more info?---------------------Tim Mitchellwww.BucketOfBits.com |
|
|
|
Jarrodr
Starting Member
11 Posts |
Posted - 2008-05-28 : 01:16:11
|
quote:
Originally posted by visakh16
whats the data type of SDATA column in your source?
Hi Visakh,I've being converting DTS package to SSIS and the SDATA in SQL 2000 was a datatype of "quotable" but in 2005 it uses "Unicode string [DT_WSTR]".This is an example of SDATA "102003 00035382261000000000000000000000000000000000NNY00000350000700000000000W20041214" |
|
|
|
Jarrodr
Starting Member
11 Posts |
Posted - 2008-05-28 : 01:17:46
|
quote:
Originally posted by tmitch
Looks like either a data type or a data length error. Can you post more info?---------------------Tim Mitchellwww.BucketOfBits.com
Hi Tim,My datatype is "Unicode string [DT_WSTR]" and length is 200. |
|
|
|
Jarrodr
Starting Member
11 Posts |
Posted - 2008-05-30 : 00:40:27
|
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. |
|
|
|
|
|
|
Error storing data in text file???