<div>
Hi,<br />
<br />
<br />
Please check the below link on sqlcmd and will help you you in solving the issue...<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms162773.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms162773.aspx</a><br />
<br />
all the best...
</div>


<div>
JagdishDevaku , the link you have provided has nothing to do with my question. This is the sqlcmd manual page, I know this manual and naturally is was my first station before I asked my question.<br />
<br />

</div>


<div>
<br />
&nbsp;sqlcmd -S.\SQLEXPRESS -d mydb -Uuser -Ppass -v 'dir c:\&gt;\\temp\bcp' -i vdc-export-import.sql<br />
&nbsp;<br />
&nbsp;
</div>


<div>
slam69, your second one was just what I needed<br />
Thanks &nbsp;for your help.<br />

</div>


<div>
<div class="content wysiwyg-content">
HI<br />
<br />
I am trying to run sqlcmd with a script variable that holds a path (see code snippet)<br />
However , sqlcmd does not know how to handle the ':' in the dir variable value and produce the following error :<br />
<br />
Sqlcmd: ':\temp\bcp'': Invalid argument. Enter '-?' for help.<br />
<br />
I have tried \: &nbsp;:: and ^: &nbsp; nothing is working<br />
<br />
Please help<br />
<br />
Thanks<br />

<pre><code id="code-131222">sqlcmd -S.\SQLEXPRESS -d mydb -Uuser -Ppass -v dir='c:\temp\bcp' -i vdc-export-import.sql
</code></pre>
</div>
</div>


HI

I am trying to run sqlcmd with a script variable that holds a path (see code snippet)
However , sqlcmd does not know how to handle the ':' in the dir variable value and produce the following error :

Sqlcmd: ':\temp\bcp'': Invalid argument. Enter '-?' for help.

I have tried \:  :: and ^:   nothing is working

Please help

Thanks

Hi,


Please check the below link on sqlcmd and will help you you in solving the issue...

http://msdn.microsoft.com/en-us/library/ms162773.aspx

all the best...

JagdishDevaku , the link you have provided has nothing to do with my question. This is the sqlcmd manual page, I know this manual and naturally is was my first station before I asked my question.




 sqlcmd -S.\SQLEXPRESS -d mydb -Uuser -Ppass -v &#39;dir c:\&gt;\\temp\bcp&#39; -i vdc-export-import.sql
 
 

slam69, your second one was just what I needed
Thanks  for your help.


sqlcmd script variables

HI

I am trying to run sqlcmd with a script variable that holds a path (see code snippet)
However , sqlcmd does not know how to handle the &#39;:&#39; in the dir variable value and produce the following error :

Sqlcmd: &#39;:\temp\bcp&#39;&#39;: Invalid argument. Enter &#39;-?&#39; for help.

I have tried \:  :: and ^:   nothing is working

Please help

Thanks

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.