<div>
Ok, but do you know a BCP clause to automatize the generation directly to UNIX txt standard ?<br />
<br />

</div>


Ok, but do you know a BCP clause to automatize the generation directly to UNIX txt standard ?



<div>
You could use the terminate line by -r &quot;\r\n&quot; but I am uncertain.<br />
<a href="http://msdn.microsoft.com/en-us/library/ms191485.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms191485.aspx</a><br />
<br />
ROWTERMINATOR=&quot;\r\n&quot;
</div>


You could use the terminate line by -r "\r\n" but I am uncertain.
http://msdn.microsoft.com/en-us/library/ms191485.aspx [http://msdn.microsoft.com/en-us/library/ms191485.aspx]

ROWTERMINATOR="\r\n"

<div>
<div class="content wysiwyg-content">
Hi Experts<br />
<br />
Do you know a way to convert a Windows text file to a UNIX text file by using BCP ?<br />
<br />
By the way <br />
Whtat's the difference betwenn &nbsp;Windows and UNIX &nbsp;line terminator <br />
Unix &nbsp;=&gt; &nbsp;\r\n<br />
Windows=&gt;\n<br />
<br />
Thanks in advance.
</div>
</div>


Hi Experts

Do you know a way to convert a Windows text file to a UNIX text file by using BCP ?

By the way 
Whtat's the difference betwenn  Windows and UNIX  line terminator 
Unix  =>  \r\n
Windows=>\n

Thanks in advance.

How to convert a Windows text file to a Unix text file by using BCP ?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Unix is a multitasking, multi-user computer operating system originally developed in 1969 at Bell Labs. Today, it is a modern OS with many commercial flavors and licensees, including FreeBSD, Hewlett-Packard’s UX, IBM AIX and Apple Mac OS-X. Apart from its command-line interface, most UNIX variations support the standardized X Window System for GUIs, with the exception of the Mac OS, which uses a proprietary system.