×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Export to TXT File and Retain Field Names in Row 1

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

Open up the package,right click on the text file icon, click 'Properties', then click the 'Properties...' button under the file name, and finally you should notice the check box to send field names as the first row.  Just check this box, click 'Finish' and you're all set.

RE: Export to TXT File and Retain Field Names in Row 1

(OP)
Yep - found it and attempted to use it.  

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...

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close