BCP Problem

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.

Quote:

Originally Posted by 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.

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

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