Hi, I want to export data in around 40 tables using bcp. The database is on sql server 2000. When i bcp each table i want the first to have column Names. Is this doable using bcp? Or should I using the datapump task 40 times to export the data to a text file. One of the key requirement is that the first row in the text file should have column names.
bcp does not have the option of putting the first row with column names. You could possibly put them in yourself using the INFORMATION_SCHEMA view called COLUMNS and a UNION to your table. I would go down the DTS route.