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 |
|
pmccann1
Posting Yak Master
107 Posts |
 Posted - 2008-01-07 : 11:05:47
|
| Hi there, wondering if someone could shed some light. I have a text file when i am in sql2000 and import it, it imports fine when io try to import it to sql2005 i get errors. is there something i need to do. It is not going into an already created table the file itself will create a new table so i am unsure why any problems should arise |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-07 : 11:11:38
|
| how are you importing it? what are the errors you get?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
 |
|
|
pmccann1
Posting Yak Master
107 Posts |
Posted - 2008-01-07 : 11:14:16
|
| MessagesError 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "FRDNAME" 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 "FRDNAME" (25)" failed because truncation occurred, and the truncation row disposition on "output column "FRDNAME" (25)" 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\Wail\Desktop\All_Alarm5.txt" on data row 9.(SQL Server Import and Export Wizard)Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - All_Alarm5_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.(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)i can see that for some reason it is defaulting to length of 50 but even when i increase this in the advanced tab to 4000 the error still comes up. I could understand if i was bringing this into an already created table and there was a problem but sql2000 has no probs bring it in as a new table and creating the correcting sizes ect for it |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-08 : 03:58:09
|
| Could you post your actual sql code?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
import problem sql 2005