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...

Thank you guys. It worked fine. 😉

You would also use single quotes for escape sequence.

Lets say you have a query like this in Oracle:

SELECT employee from Departments where employee='John'

In order to have it run in SQL...

SSIS_NewBi (6/5/2010)

---

I was able to solve your issue.

As mentioned in this thread you can use the Pivot transformation to convert the file. But for Pivot you would need 3...

How would you have everything before (=) sign as name of the column and after the sign would be the rows.

here is an example: