Link to home
Start Free TrialLog in
Avatar of marrowyung
marrowyung

asked on

Error when importing text file using import wizard

Dear all,

We tried to import a txt file using SQL 2008 import wizrd, and we get error, anyone know what it means?

DBA100. User generated image
Avatar of djon2003
djon2003
Flag of Canada image

The first error talks about Encoding. I would try to open it in notepad and save it in Unicode format.
After that, if there is still the second error, I would look the format of the data in the file.
SOLUTION
Avatar of raja_ind82
raja_ind82
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
The flat file defaults initially all columns to characters with length
of 50. You can change this by going to the “Advanced” page of the Flat
File connection page and change the length manually, or you can click on
"Suggest Types..." to get suggested column metadata attributes based on
sampling a certain number of rows from the file."
Avatar of mcs0506
Hi,
I have a little tweak , first you export text file from that table where you want to import and then compare the both text files and hopefully you find the error from text file.


Regards,

Dani
Avatar of marrowyung
marrowyung

ASKER

mcs0506:

it is a bit complicate but we are trying to cahnge different option, we have use "suggested types" but it doesnt' works.

DBA100.
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
DFW_Ed,

Is there any good example of bcp part of the table as a backup? and then later on import it back when we need to antoher table with the same structure?

For exampe, BCP out part of the table to a txt file, then we create another table with different name of the same schema, then we import txt file back to that new table ?

DBA100.
finally we don't do this.