Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 BCP Problem

Author  Topic 

joy
Starting Member

5 Posts

Posted - 2005-06-01 : 03:39:05
Is there any way to extract the header info in the first row while extracting data from a table using BCP.

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-06-01 : 05:11:42
[url]http://weblogs.sqlteam.com/brettk/archive/2005/04/13/4395.aspx[/url]

rockmoose
Go to Top of Page

joy
Starting Member

5 Posts

Posted - 2005-06-01 : 07:31:33
Thanks For the reply. But I need some thing where i don't need to run a SP. Is there any parameters for BCP which will generate the header info in the first line.
Go to Top of Page

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-06-01 : 07:39:35
No.

rockmoose
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-06-01 : 08:35:42
osql can create column headers, but you don't have the control over formatting that bcp does. Look in Books Online under "osql" to learn more.
Go to Top of Page
   

- Advertisement -