Post reply

Output from .BAT file into Global variable in DTS Package

  • November 12, 2006 at 3:21 am

    #69147

    Hi All,

    I have few questions about DTS tasks.

    1. In my DTS package, i am executing a BAT file, which in turn calls an EXE and returns a RequestID Which i need to use in subsequent Execute SQL tasks.

    Any one can tell me how to take this output in to global variable and use the same in next steps? If you can post a code for this, that would be greatly appreciated.

    2. I am using a ActiveX script to create a file dynamically and need to give  write and delete permissions to  user X for the same file.

    Thanks in advance for your help.

    Thanks,

    Ambati

     


    padma

  • November 13, 2006 at 8:45 am

    #671379

    I have never done this, but if I were to do it, I would write the result to a text file then read the text file in an Activex task using the File System Object. There are a lot of examples out there. Just Google on "Scripting.FileSystemObject".

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply