"Omnibuzz" wrote:

> I hope you didn't give it in the SSMS. you are supposed to give it in command
> prompt

"GH" wrote:

> When I run the following BOL example:
>
> bcp AdventureWorks.Sales.Currency out Currency.dat -T -c
>
> I get the following error message:
>    Msg 102, Level 15, State 1, Line 2
>    Incorrect syntax near '.'.
>
> I have tried multiple variations ... still get the same error ...
>
> This cannot be this hard.
>
> --
> Thanks in advance
> G

"Enric" wrote:

> Please find attached personal examples for that stuff...
>
> C:\>bcp abs.abs_diario in c:\20050929.dat -n -Ssql4 -Uusrdts1 -Pdts1
> C:\>bcp ABS_Diario_Dat in Diariomes10.dat -c -U ABS -P -S SQL1
> C:\OFI0501>BCP abs.dbo.ABS_OF501 IN 20050726.DAT -e enric.txt -C -c  -Ssql4
> -Uusrdts1 -Pdts1
>
> hope that helps
>
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''''s hard to provide information
> without seeing the code. location: Alicante (ES)
>
>
> "GH" wrote:
>
> > When I run the following BOL example:
> >
> > bcp AdventureWorks.Sales.Currency out Currency.dat -T -c
> >
> > I get the following error message:
> >    Msg 102, Level 15, State 1, Line 2
> >    Incorrect syntax near '.'.
> >
> > I have tried multiple variations ... still get the same error ...
> >
> > This cannot be this hard.
> >
> > --
> > Thanks in advance
> > G