Hi,

What I'm trying to do is create a text file based on the contents of a
stored procedure. However, the stored procedure may return one or more
recordsets and the format of these recordsets is dynamic.

What I'd like to do is dump any data that the procedure returns to a
comma or tab separated file. I don't think I can do this using the DTS
Designer, because it requires me to create transformations in the
Transform Data Task. I can't do that when I don't know what output the
stored procedure will come up with.

Can anyone recommend a way to do this?

Many Thanks,

Darren