I have a developer that is trying to write an ActiveX
script step inside a DTS package that calls a stored
procedure which executes an UPDATE statement. After the
update statement runs a select is executed to populate the
output parameters of the stored procedure. The output
parameters do not get returned to the DTS ActiveX script
step. I have reviewed Darren Green's article on "Global
Variables and Stored Procedure Parameters"
(http://www.sqldts.com/default.aspx?234) for help but have
not been able to get the ActiveX script to work.

Can an ActiveX script perform the same processes that
Darren describes in his article?

Thanks in advance for everyone's help!!

Scott Lindsey
Highlights for Children

Most probably but if the article does what you want then why would you want
to do it in an Active Script task ?

http://authors.aspalliance.com/steve...les/sprocs.asp

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Scott Lindsey" <sflindsey (AT) highlights-corp (DOT) com> wrote

In article <0c6b01c3c665$11db5810$a501280a (AT) phx (DOT) gbl>, Scott Lindsey
<sflindsey (AT) highlights-corp (DOT) com> writes
Why? If DTS has a task to do this then why not use it?

If you must use ADO, then code it like any other app, making sure you
include SET NOCOUNT ON at the beginning of the T-SQL to ensure you only
get one result set back to populate your recordset.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Many thanks for the solution! It worked without a hitch!
Thx again!
Scott

Allan,
Many thanks for the response. The link gave me some very
helpful information!
Thx again,
Scott