DTS: export data with multiple SELECTs in one transformation

[cricketer1]

Can I use more than one SELECT statments to export data from a DTS package in one DATA TRANSFORMATION. If so how can it be done.
Situation: I want to export data to the same text file through the same DATA TRANSFORMATION but there are more than one SELECT statments so essentially the data should be appended to the text file but within the same transformation.

Thanks
cricketer1

 

[foxdev]

Can the data be UNIONed, or is it a different format altogether? Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com

 

[cricketer1]

Hi Robert, Yes the data is a different format for each of the select statements.

cricketer1