Re: DTS and VB.net....Capturing return value

#1

ninel wrote:

Quote:

I am executing a DTS package from vb.net. This package executes a
stored proc which is supposed to return a return value.

Here is my .net code:

Dim oPkg As DTS.Package2
Dim oStep As DTS.Step2
Dim results As Boolean

results = True
oPkg = New DTS.Package2

oPkg.LoadFromSQLServer(ServerName:="NINEL-D246655F1",
ServerUserName:="timecontroluser",
ServerPassword:="timecontroluser", PackageName:="ExportTSRLog")

oPkg.GlobalVariables.Remove("sCalldate")
oPkg.GlobalVariables.AddGlobalVariable("sCalldate" ,
sCalldate)

For Each oStep In oPkg.Steps
oStep.ExecuteInMainThread = True
Next

oPkg.FailOnError = True
oPkg.Execute()

For Each oStep In oPkg.Steps
If oStep.ExecutionResult =
DTS.DTSStepExecResult.DTSStepExecResult_Failure Then
results = False
End If
Next

If results = True Then
lblResult.Visible = True
lblResult.Text = "TSRLogs have been exported"
End If
oPkg.UnInitialize()
oStep = Nothing
oPkg = Nothing

ExecuteDTS = results

I can not figure out how to capture this value on the vb.net side.
Do I need to do something special in the DTS package aside from just
setting the reeturn value in the stored procedure?

Can anyone help?

Thanks,
Ninel

To execute a proc and get a return value, why not use ADO.Net? I assume
you are doing more than that, so you still want DTS.

Forget about .Net for a minute, and set tech Exec SOL Task to return the
proc return code to a global variable. Once that is working, adjust the
..Net code to read the global variable post execution.

Global Variables and Stored Procedure Parameters
(http://www.sqldts.com/default.aspx?234)

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS and VB.net....Capturing return value

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: DTS and VB.net....Capturing return value - 08-18-2005 , 05:59 PM