sql server dts: Active X and stored procedures -- sql server dts

Re: Active X and stored procedures

Gary
9/13/2005 10:35:02 PM

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

[quoted text, click to view]

Re: Active X and stored procedures

Allan Mitchell
9/14/2005 12:00:00 AM

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

[quoted text, click to view]

Re: Active X and stored procedures

Allan Mitchell
9/14/2005 12:00:00 AM

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

[quoted text, click to view]

Re: Active X and stored procedures

David J. Cartwright
9/14/2005 8:31:24 AM

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/default.asp?url=/library/en-us/sqldmo/dmoref_m_e2_8jz8.asp

Is this close to what you need ?

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.