Stored Procedure result set -> export

[bigfoot]

I have a lengthy stored procedure that takes parameters that returns a recordset. I want to export the returned recordset to a comma delimeted file. How do I do this in DTS?

I have worked with DTS a lot, but it's been with tables. This has no table object to connect to. I can't seem to get past the data transformation part of the query dialog.

 

[tb]

You might find this site useful . . .

http://www.sqldts.com

Good luck


I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!

 

[bigfoot]

Thanks. Got that one.

Figured it out.