Is there documentation/website/tutorial on how to create a bcp file
manually? In one project, I need to generate a bcp file from infromation
inside a DataTable but not sure what the file needs to look like.

-BKN

Hello Bryce,

What do you mean a BCP File? Do you mean a format file or do you mean the
exported data?


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

The exported data. In other words, I need to create a file that I can use
the BCP utility program to import the data into. But I have no idea what the
format of this file should be.

-BKN

Hello Bryce,

The thing about BCP is it imports into or exports from. So you can either
import into SQL Server from a text file or you can export from a sql server
table to a flat file.

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


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

I understand that, what I was asking is what the file needs to look like to
do the export. I'm creating the file in code (not using BCP) and then need
to use BCP to import the file into the SQL Server, but I need to know what
format this file should look like.

-BKN