DTS through JOB | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS through JOB

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=’:)‘ />]
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.
hmmmm.. Thanks for response. That means there is no way to do this ah. D!shan
Not so with SP_START_JOB, as far as I’m concerned. 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.
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
]]>