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 |
|
devisetti
Starting Member
30 Posts |
 Posted - 2008-05-16 : 05:33:49
|
| Guys ,I have generated a pipe delimited file using bcp option.I am getting the ouput for some columns as some some special characters(boxes). When ,I have checked my source data in few columns the data is stored with single space.I can see this special character when opening with editplus only not with notepad. This flat file will be used to load into oracle table.because of this reason all the rows are failing.Do ,I need to fix this space issue in my stored procedureAny suggestions.. to avoid this special character when generating the flatfile.thanks in advance |
|
|
mathiyazhagan.sekar@gmail
Starting Member
11 Posts |
Posted - 2008-05-16 : 09:26:33
|
| Hi, I could not get what you asking for. The logic of sp and/or sample data will help to find the solution.Cheers,MathiIndia. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-16 : 10:34:14
|
| what are these characters really? Some foreign langauage or unprintable characters? |
|
|
|
|
|
|
Specail characters in flat file