February 1, 2007 at 3:30 pm
Does anyone know how to return a value to a SQL2K DTS Package from the output parameter of a SQL2K stored procedure?
February 1, 2007 at 3:37 pm
February 1, 2007 at 3:51 pm
I'm sorry, I should have been a little more explicit in my question. I need to call the stored procedure from, and return the stored procedure output parameter value to, an ActiveX Script Task (VB Script).
February 1, 2007 at 4:13 pm
What this discusses is getting the data into a global variable from the output parameter of a stored procedure. http://www.sqldts.com/234.aspx
From there you can refer to the global variable in you ActiveX script.
Russel Loski, MCSE Business Intelligence, Data Platform
February 2, 2007 at 7:09 am
Yes, it does. However it discusses it using an Execute SQL Task. There are reasons I cannot use an Execute SQL Task. I need to do it using an ActiveX Script Task and VBScript.
February 2, 2007 at 9:32 am
You are going to need to use an ado.command object with a parameter of type output. You will need to pass in a connection string (or hard code it). Do a search on VBScript and "ADO.Command" and see what you find. You can use an ADO.Command; I just haven't seen the need.
The thread in the following sounds very much like our exchange so far.
http://www.dbtalk.net/microsoft-public-sqlserver-dts/need-example-exec-proc-vbscript-163469.html
Russel Loski, MCSE Business Intelligence, Data Platform
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply