Export to TXT File and Retain Field Names in Row 1
Export to TXT File and Retain Field Names in Row 1
(OP)
I have created an export DTS; which works great, with one exception. The user has requested that the first row of the TXT export contain the field names from the view being exported. I searched the DTS Data Pump object interface and did not see this as an option. Am I missing something? Should be a simple checkbox I hope. Thanks in Advance!
Steve Medvid
IT Consultant & Web Master
http://www.saveourfarm.com
Chester County, PA Residents
Please Show Your Support...
RE: Export to TXT File and Retain Field Names in Row 1
RE: Export to TXT File and Retain Field Names in Row 1
However the last two fields of my 165 column export failed to appear in the text file. The source is a view which effectively combines 8 separate views. Unfortunately, 6 of the 8 views are cross tab in nature and semi-complex. My current design is to send each of the 8 views into a #temp table and index primary key; then perform an insert into a real table via a select joining each of the 8 #temp tables (now using an indexed field). Hopefully the table approach will work better. The #temp table approach improved performance greatly. 25 minutes to 11 minutes to produce results.
Thanks!
Steve Medvid
IT Consultant & Web Master
http://www.saveourfarm.com
Chester County, PA Residents
Please Show Your Support...