|
|
Posted by Jason Lepack on 07/05/07 14:40
See Bob Bojanic's post here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=141512&SiteID=1
On Jul 5, 10:20 am, Sharif Islam <mis...@spam.uiuc.edu> wrote:
> Hi,
> I am new to SQL 2005. My text import with DTS in SQL 7 ( my previous
> version) works fine. I check the column URL, the data seems to be ok. I
> set it to varchar and length 255 ( I tried higher as well). Any idea?
>
> - Executing (Error)
> Messages
> * Error 0xc02020a1: Data Flow Task: Data conversion failed. The data
> conversion for column "URL" 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: The "output column "URL" (42)"
> failed because truncation occurred, and the truncation row disposition
> on "output column "URL" (42)" 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: An error occurred while processing
> file "C:\Documents and Settings\Desktop\merged.txt" on data row 4.
> (SQL Server Import and Export Wizard)
>
> * Error 0xc0047038: Data Flow Task: SSIS Error Code
> DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source -
> merged_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. There may be error
> messages posted before this with more information about the failure.
> (SQL Server Import and Export Wizard)
>
> * Error 0xc0047021: Data Flow Task: 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.
> (SQL Server Import and Export Wizard)
>
> * Error 0xc0047039: Data Flow Task: SSIS Error Code
> DTS_E_THREADCANCELLED. 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. There may be error
> messages posted before this with more information on why the thread was
> cancelled.
> (SQL Server Import and Export Wizard)
>
> * Error 0xc0047021: Data Flow Task: SSIS Error Code DTS_E_THREADFAILED.
> Thread "WorkThread0" has exited with error code 0xC0047039. There may
> be error messages posted before this with more information on why the
> thread has exited.
> (SQL Server Import and Export Wizard)
Navigation:
[Reply to this message]
|