SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-01-2008, 02:46 PM
| ||||
| ||||
 Generating BCP input file from Perl/Unix Hi, I am attempting to process a proprietary formatted file into flat csv for the purpose of bcp'ing into a SQL Server 2005 install. I tried writing a processor in Perl that "works" except that the BCP tool in windows just does not like the file, it gives me the "Unexpected EOF...." error that is usually associated with misaligned fields. I am pretty sure the cause of this is the end of line character differences between platforms. I did some tests with a single row manually inserted and bcp'd out of the SQL Server using csv format, and the formatting looks identical to my perl output file. When I get the hex editor involved, I can see the bcp output has 2 characters at the end of each line (LF and CR if I am correct) whereas the unix output has only 1. I have been unable to get the perl script to output the right eol characters for BCP to work. I wrote another processor in C# under windows that works perfectly. Is there a solution in perl? how do I terminate the lines properly? is there a way to get BCP to recognize and accept different eol characters? Any advice is appreciated. Thanks.      |
 |
« running a vbs file as a step of an SqlServer job
|
Database/Table Design Question - Object/Event Model »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 12:44 PM.
