Output to multiple text file based on query

Question

Output to multiple text file based on query

hasan.askari

Mr or Mrs. 500

Points: 535
More actions
September 24, 2010 at 11:52 am

#142089

Hello,
Can anybody please tell me how to have an output on multiple file from a single query based on the result.
For example,
If I have a query:
SELECT Name, Address FROM Customer WHERE Name='JOHN' OR Name='BEN'
Now, I want to output the results for two customers in their specific file i.e. JOHN_FILE and BEN_FILE.
Please let me know, what transformation would I have to use?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

hasan.askari (9/24/2010)
Hello,
Can anybody please tell me how to have an output on multiple file from a single query based on the result.
For example,
If I have a query:
SELECT Name, Address FROM Customer WHERE Name='JOHN' OR Name='BEN'
Now, I want to output the results for two customers in their specific file i.e. JOHN_FILE and BEN_FILE.
Please let me know, what transformation would I have to use?

Use a DataFlow with a Condition Split that checks for Name = John or Name = Ben. Direct one output from the Condition Split to the John file and the other to the Ben file.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

hasan.askari Mr or Mrs. 500 Points: 535 More actions · Answer 2

Alvin Ramard (9/24/2010)
hasan.askari (9/24/2010)
Hello,
Can anybody please tell me how to have an output on multiple file from a single query based on the result.
For example,
If I have a query:
SELECT Name, Address FROM Customer WHERE Name='JOHN' OR Name='BEN'
Now, I want to output the results for two customers in their specific file i.e. JOHN_FILE and BEN_FILE.
Please let me know, what transformation would I have to use?
Use a DataFlow with a Condition Split that checks for Name = John or Name = Ben. Direct one output from the Condition Split to the John file and the other to the Ben file.

Thanks Alvin. That helped.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 3

You're welcome.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]