Return response code to DTS 3

[theniteowl]

Hi All,
I have a VBS script I wish to have called from SQL DTS.
Can I return a response code to DTS to indicate success or failure?

I am not handling the DTS portion of this, I am just providing some code to automate the FTP of a file and it would be nice to tell them they can check for a return response so they know if the process completed.

Thanks.

At my age I still learn something new every day, but I forget two others.

 

[markdmac]

I believe this is what you want:
wscript.quit(exitcode)

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[theniteowl]

I believe this is what you want:
wscript.quit(exitcode)

That's it. I thought I had seen it in the past but my searches turned up nothing.

Should the exit codes always be numeric or can it return a text string? I am not sure how they will want to implement handling of the error code in the DTS package, numerical would probably be fine but it's nice to be able to give options if possible.

Thanks.

At my age I still learn something new every day, but I forget two others.

 

[markdmac]

I believe it has to be numeric but cannot confirm this.

I hope you find this post helpful.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/script56/html/277933cd-478e-4a45-86c8-9d96547bb515.asp

Bottom line: Numeric

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[markdmac]

Thanks for the confirmation PHV.

 

[ddiamond]

I also have been trying to figure out how to return an error code from vbscript. This posting was exactly what I was looking for. Have another star mark.

 

[dilettante]

The parentheses are incorrect. In this case they are merely redundant. Use:

[tt]WScript.Quit exitCode[/tt]