Post reply

Run DTS with input parameters from a Stored Proc

  • July 17, 2003 at 10:46 am

    #83928

    I found the posting titled "Execute DTS package using OA procedures" that executes a dts package but I need to pass input parameters to the package. Does anyone know how to do this?

    Thanks,

    David

  • July 21, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • July 23, 2003 at 1:53 pm

    #466650

    I have a DTS package that contains lots of Execute SQL Tasks. To pass parameters to these tasks, I go to Package Properties, Global Variables tab, and define variables there.

    There are two variables I use: a date and a type. They are both set before the Execute SQL Tasks run. They are set with an Active X script task. (ex DTSGlobalVariables("today").value = date())

    In the tasks themselves, I put a question mark and associate it to the global variable.

    This works for my team but there very well may be a better way!

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

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