Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005
    Posts
    12

    Question Unanswered: Replacing parameters in DTS ExecuteProcessTask

    I'm having hard time executing Win32 process with "E(xecute) P(rocess) T(ask)" in my DTS package since it does not allow dynamically setting the parameters property. Is there a way (VB Script in Active Script Task) to modify the parameters for the EPT programmaticaly. A way to identify the task within the package, modify its "parameters" property and after all that, based on "On sucess" workflow precedence, run the modified task?

    Running the same Win32 process with xp_cmdshell in "Execute Sql Task" does not produce the required results. I'm trying to send an email with attachment using sendemail.exe cmd application and everything is ok, but mail never comes to the intended recipient. Using the same xp_cmdshell from the QueryAnalyzer works fine.

    Thanks for the help,
    Andrej

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    I had the same problem, check AV on that machine, for port 25 blocking or mass email blocking. The DTS package will use the environment of the SQL server, not the client.

Posting Permissions

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