If i call a DTS from a VB program, is it possible to get
a return code from it much the same as you would from
calling a function ?

In article <01f301c3c98e$a15950b0$a301280a (AT) phx (DOT) gbl>, Peter Newman
<anonymous (AT) discussions (DOT) microsoft.com> writes
You need to use the ExitProcess API function-

Public Declare Sub ExitProcess Lib "kernel32" _
(ByVal uExitCode As Long)


Sub Main()
.....

ExitProcess 1

End Sub


Beware-

http://support.microsoft.com/default...b;EN-US;288216

Search the VB groups for more info if you want.

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

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