marrowyung
asked on
Error when importing text file using import wizard
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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."
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."
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
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
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER
finally we don't do this.
After that, if there is still the second error, I would look the format of the data in the file.