issue about dts - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

issue about dts

Author

Topic

dasu
Posting Yak Master

104 Posts

Posted - 2004-08-18 : 10:06:45

Now my doubt is how to call a stored procedure in the activex script
here important is i have one out put parameter for above stored procedure.i have to catch that value in activex script and i want to
print that.
tell me the solution please...
active xscript is completely vb code

nr
SQLTeam MVY

12543 Posts

Posted - 2004-08-18 : 10:13:44

http://www.nigelrivett.net/DTSExecuteStoredProcedure.html

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2004-08-18 : 10:14:37

HTH..
http://www.nigelrivett.net/DTSExecuteStoredProcedure.html

OOPS.. I was late..

- Sekar

dasu
Posting Yak Master

104 Posts

Posted - 2004-08-18 : 10:24:23

ok ur suggested solutions are very high range.
i think u knew dts packages in enterprise mangaer in that iam trying
to create one package inthat i have activex scrit like this
Function Main()
Main = DTSTaskExecResult_Success
MsgBox DTSGlobalVariables("shubhanshTest01").Value
End Function
and

execute sql task is like thisDeclare @status Varchar(30)
EXEC pr_cbs_pull_request_details 't_cbs_req', 1,1, @status output
SELECT @status AS statusValue

so now i want getto output parameter value into active x script
conection and every thing ok
just i want to catch output parameter return by stored procedure

i think this is enough info

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources