Hello, I want to write the results of a stored procedure to a text file in
active x task in dts. I have the code to write the text file but what I need
is an example of executing a stored procedure with a parameter and the
results writing to a text file.
The parameterin question comes from the package globa variable.

Thanks in advance for your help.

Gary

Why do you need to do this in an Active Script task?

A stored proc + param can act as the source to a datapump task.

You could try this article

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)


Allan




"Gary" <Gary (AT) discussions (DOT) microsoft.com> wrote

I appreciate your reply but the website and page you posted do not address
my question.


"Allan Mitchell" wrote:

If you must use ActiveX, you can use SQLDMO To Connect to Server and Execute
a Command with results then use FSO to write to file
http://msdn.microsoft.com/library/de..._m_e2_8jz8.asp

Is this close to what you need ?

"Gary" <Gary (AT) discussions (DOT) microsoft.com> wrote

Then what does your stored proc return?
Why must you use an Active Script task?
Why is a datapump task with the stored proc as the source not
appropriate?

Allan




"Gary" <Gary (AT) discussions (DOT) microsoft.com> wrote