Errors getting Import data csv file to sql2005..?

Question

0.00/5 (No votes)

See more:

hi i have import the data from Csv file to sql2005 ,i am getting below errors please help me..?

* Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "Column 29" 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 "Column 29" (126)" failed because truncation occurred, and the truncation row disposition on "output column "Column 29" (126)" 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:\Users\ravi\Desktop\Cus_csv.csv" on data row 16.
(SQL Server Import and Export Wizard)

* Error 0xc0047038: Data Flow Task: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "Source - Cus_csv_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. 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)

Posted 21-Sep-12 22:58pm

Gujula Ravindra Reddy

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2012-09-21T23:08:00

The error messages are pretty explicit:
The data conversion failed, because (it would appear) you are trying to import data that is too long for the field it is going into.

The best solution would be either to modify your source XML (if you are doing this as a one off and there isn't a lot of data) or to change the database definition to allow for the maximum length of your XML fields.

Dineshshp · Answer 2 · 2012-09-21T23:44:00

Solution 2

you want to import a csv file into sqlserver database table.

but csv file doesn't contains information about datatypes of data stored in csv file.

SOLUTION:

you must to match your csv data manully with datatype, size, length with your sqlserver table fields in which u want to import.

Posted 21-Sep-12 23:44pm

Dineshshp