SSIS Import Wizard Errors
- From: Janet <Janet@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 27 Jul 2006 06:16:01 -0700
Installed an upgrade from 2000 sp4 to 2005 sp1. Trying to import simple flat
file of 30,000 records but getting error that told me nothing. Somebody
suggested installing SP1 on my local machine to get better error reporting,
which I did. Now the error is a truncation error. However, in the wizard
(it's a very simple import, like my brain), using the advanced setting and
asking sql to suggest types, and getting the following error. But what
doesn't make sense to me is that I've changed the output on that field to
varChar(100). Isn't the purpose of a wizard to accommodate someone like me
who isn't a full-fledged dba?
I've figured out a way to do a command line run of the old dtsrun.exe
utility in the interim. (By the way, the dtsrun executes and imports the data
fine into 2005.) But, I'd like to figure out how one does implicit
conversions with a wizard? And, I need to get the basics of the SSIS down.
Suggestions of online tutorials would be appreciated....
Executing (Error)
Messages
Error 0xc02020a1: Data Flow Task: Data conversion failed. The data
conversion for column "Pat L Name" 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 "Pat L Name" (50)"
failed because truncation occurred, and the truncation row disposition on
"output column "Pat L Name" (50)" 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
"X:\misys\sqlImports\pmPatientInfo.csv" on data row 106.
(SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task: The PrimeOutput method on component
"Source - pmPatientInfo_csv" (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.
(SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with
error code 0xC0047038.
(SQL Server Import and Export Wizard)
Error 0xc0047039: Data Flow Task: 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.
(SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error
code 0xC0047039.
(SQL Server Import and Export Wizard)
.
- Follow-Ups:
- Re: SSIS Import Wizard Errors
- From: Allan Mitchell
- Re: SSIS Import Wizard Errors
- Prev by Date: Re: error in sql dts job .. help :(
- Next by Date: Re: Can't Import numeric field from Foxpro to SQL using DTS
- Previous by thread: Re: Can't Import numeric field from Foxpro to SQL using DTS
- Next by thread: Re: SSIS Import Wizard Errors
- Index(es):
Relevant Pages
|
