Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS download table to text file

Status
Not open for further replies.
Morningstarr

Morningstarr

Programmer
Mar 13, 2002
24
US
Using SQL 7.0, I want to use 1 dts package to download different tables into a text file. The problem I am having is that the fields in the destination (text file) will be different depending on which table is being downloaded. Is there a way to set the fields in the textfile destination dynamically using the field names from the source table, each time a table is copied? I am using an active x script to change the sql statement in the datapump each time the job is run.
Thanks,
Dawn
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
972
BobSuruncle
BobSuruncle
Cpreston
  • Locked
  • Question
Seconds to minutes 2
Replies
5
Views
2K
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
754
Mike Lewis
Mike Lewis
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
Billz66
  • Locked
  • Question
need to udate table entry with number containing a *
Replies
11
Views
629
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top