dts issue?? please - 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)

dts issue?? please

Author

Topic

dasu
Posting Yak Master

104 Posts

Posted - 2004-08-19 : 04:18:21

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