BCP Problem

[rsrinivasan]

Hi all,

Im using bcp utility to copy all the data from a table to file. The file is created as it is. But i cant open that bcp file. How can i open this file.

Thanks in advance,
Srinivas r.

[davef]

Hi all,

Im using bcp utility to copy all the data from a table to file. The file is created as it is. But i cant open that bcp file. How can i open this file.

Thanks in advance,
Srinivas r.

What format is your output file?
This works for me (mixed authentication) :
bcp <dbname>.<schem a>.<table-name> out "C:\Test.da t" -c -U <user-name> -P <password> -S <server-name\instance-name>

http://msdn2.microsoft.com/en-us/library/ms162802.aspx