On Oct 15, 12:10*pm, "Roy Harvey (SQL Server MVP)"
<roy_har...@snet.netwrote:
On Wed, 15 Oct 2008 09:03:57 -0700 (PDT), "bobdu...@gmail.com"
<bobdu...@gmail.comwrote:
I'm trying to run an import of some data that has unix style carriage
returns throughout (ie, 0x0A, or \n). *When i use osql to import the
data, it shows up in the SQL Server 2005 database as 0x0D 0x0A or \r
\n.
I do not want this behaviour - the import file is very large and has
ddl at the beginning. *Can anyone suggest a more suitable utility or
method for importing this data that will preserve the original
format? *Or perhaps my database is not configured correctly?
I haven't had to work with that type of data that I can recall, but I
do wonder how you use OSQL to import data. *BCP, DTS, SSIS, BULK
INSERT sure, but not OSQL, which is for executing SQL commands.
Roy Harvey
Beacon Falls, CT
Hi Roy,
The .sql file has all the "create table" and "insert into" commands.
I just run the command like this:
c:\osql -U sa -P blahblah -d mydb -i C:\myimportfile.sql
All the data imports fine, except the simply 0x0A's in the data - they
appear in the db as 0D0A's.
If i look at the .sql file before import in a hexeditor there is
clearly no 0D's in the data itself.
Bob