all groups > sql server dts > may 2006 >
You're in the

sql server dts

group:

manually create a bcp file


manually create a bcp file Bryce K. Nielsen
5/17/2006 8:33:25 AM
sql server dts:
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

Re: manually create a bcp file Allan Mitchell
5/17/2006 4:28:23 PM
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

[quoted text, click to view]

Re: manually create a bcp file Bryce K. Nielsen
5/18/2006 11:54:02 AM
[quoted text, click to view]

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

Re: manually create a bcp file Allan Mitchell
5/18/2006 4:31:11 PM
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

[quoted text, click to view]

Re: manually create a bcp file Bryce K. Nielsen
5/19/2006 12:07:14 PM
[quoted text, click to view]

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

AddThis Social Bookmark Button