Post reply

Insert trigger that passes parameters to DTS Pkg

  • November 22, 2002 at 1:10 pm

    #158389

    I need to create a insert trigger that calls and passes the values of the currently inserted record to a SQL 7.0 DTS pkg that will

    extract data based on the parameters into text files.

  • November 22, 2002 at 1:41 pm

    #442155

    I think you can execute a DTS package when a Insert trigger fires Using DTSRUN Utility.

  • November 22, 2002 at 1:48 pm

    #442157

    The problem is not calling the package. The problem is how do I pass the values that are being inserted into the source record into variables within the DTS package. The flow is:

    1) Someone enters data into my table,

    2) The insert trigger passes the values of the record to a DTS task (I don't know which task would work best in this situation),

    3) The pkg would execute creating text files based on the parameters passed from the insert trigger

  • November 22, 2002 at 2:02 pm

    #442159

    I don't think you can pass the variable values into the DTS task from the trigger.But try taking the values into the global variables and using those variables in the DTS task(ActiveX script).

Viewing 4 posts - 1 through 3 (of 3 total)

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