Export SQL Column Header

Support for DataSlave

Moderators: Tom, ian

Export SQL Column Header

Postby breener96 » Mon Feb 13, 2012 4:47 am

I am exporting data directly from SQL to a text file. I want to include the names of the columns in my export. Is there a way to do this?
breener96
 
Posts: 10
Joined: Fri Oct 15, 2010 12:22 am

Re: Export SQL Column Header

Postby ian » Mon Feb 13, 2012 10:55 pm

Yes this is certainly possible.

Use a MS SQL Read object to read data from a SQL table into DataSlave. Then use a Text Write object to export the data to a delimited file ticking a checkbox to include column headers.

If you wish we can arrange a GTM session to demonstrate this. Please email sales to set-up a session
ian
 
Posts: 364
Joined: Sat Dec 18, 2004 8:13 am
Location: UK

Re: Export SQL Column Header

Postby breener96 » Tue Feb 14, 2012 5:07 am

Wow - I cannot believe that I missed that checkbox. Thanks!
breener96
 
Posts: 10
Joined: Fri Oct 15, 2010 12:22 am


Return to Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron