dcsimg
Results 1 to 2 of 2

Thread: Capturing returnValue from DTS package executed from vb.net

  1. #1

    Thread Starter
    Member
    Join Date
    Mar 2005
    Posts
    40

    Capturing returnValue from DTS package executed from vb.net

    I got as far as being able to execute a dts package from vb.net. The dts package passes a global variable to a stored procedure.

    How can I capture the returnValue of the stored procedure in vb.net? I'm stuck and can't figure it out.
    Can anyone please help me?

    Thanks,
    Ninel

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    32,566

    Re: Capturing returnValue from DTS package executed from vb.net

    I don't know that there is a way.... except to maybe store it in a table, then after the DTS is run, do a query on the table to get the value.... ?????

    Tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width