SQL Server Performance

DTS through JOB

Discussion in 'SQL Server DTS-Related Questions' started by dishanf, Mar 1, 2004.

  1. dishanf New Member

    Hi experts.<br /><br />is there a way to pass a parameter when calling a SQL Server job, that in turn passes the parameter to a DTS package. now im execute Job using sp_start_job. but i cant findout, is there a way to pass parameters.<br /><br />DishanF [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
  2. satya Moderator

    I don't think its possible to pass parameter to a scheduled job.
    And in DTS package use GLOBAL Variables you can pass as parameter using DTSRUN Utility, for more information review Books online andhttp://www.sqldts.com website.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. dishanf New Member

    hmmmm.. Thanks for response. That means there is no way to do this ah.

    D!shan
  4. satya Moderator

  5. gaurav_bindlish New Member

    Store the input data in a table and program the job to read data from that.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard

Share This Page