osql import inserting carriage returns?

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?

Thanks,
Bob
.

Relevant Pages

  • Re: Create Job to dump SP results into a text file.
    ... But its output is in a strange format. ... > As the first content you get, it is because the missing of some switches in> the OSQL utility, and the -L is an exclusive switch in osql utility, so you> get the content of 'The -L parameter can not used in combineation with> others parameters.' ... Could you connect the SQL Server via Query Analyzer by SQL Server> authentication using 'sa'? ...
    (microsoft.public.sqlserver.programming)
  • RE: msde local server
    ... If you haven't installed MSDE, ... After you install, it, you can use osql (command-line tool that comes with ... MSDE) to connect to the instance and create a database. ...
    (microsoft.public.sqlserver.msde)
  • Re: OSQL usage
    ... "Piyush" ha scritto nel messaggio ... > Is it possible to create a database at a specified ... > location using OSQL? ... you can download the SQL Server Books On Line at ...
    (microsoft.public.sqlserver.msde)
  • Re: User not associated with trusted SQL Server connection
    ... from sysusers" in the database and see what userids already exist.. ... >> using the osql utility. ... >> associated with a trusted SQL Server connection. ... >>>> have trusted access to SQL Desktop version. ...
    (microsoft.public.sqlserver.security)
  • SQL-Server access from a Workstation
    ... The user had MSDE from before with Win NT authenticaton only. ... Then we used OSQL and sp_addlogin. ... we could not access the database from even the server! ... This enabled us to access the database from ...
    (microsoft.public.sqlserver.msde)