Output to multiple text files

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jason Callas (JayCallas_at_hotmail.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 11:46:13 -0500

Based on a single query, I need to output the row data to different files
depending on a specific column value. For example:

Query results

Symbol Shares Exchange
--------- -------- ----------
MSFT 1000 XNAS --> write to XNAS.csv
DIA 500 XNYS --> write to DIA.csv
AAPL 750 XNAS --> write to XNAS.csv

I am not sure how to set this up. My initial thought was to set up a
destination for a text file. Then in the ActiveX Main function to write out
the data to the actual file then exit out of function telling DTS to skip
the record. This would work but I am hoping for a cleaner solution.

Any thoughts?

Thanks,
Jason