Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2011-12-12 : 10:48:30
|
| my ssis package is called via a job.i.e.: EXEC msdb..sp_start_job @job_name = @JobName Is it possible to add an extra parameter here, i.e. pathname such as: EXEC msdb..sp_start_job @job_name = @JobName, @PathNamewhere @pathname is used inside the ssis package?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-12 : 10:52:31
|
| nope. the pathname should be configured inside the job step.You cant pass additional parameters like this to sp_start_jobIf you want to interactively pass pathname the best way is to call the package programmatically using DTExec utility and pass @PathName as a variable to it. If you want t incorporate this inside job you can create a configuration table to store path name and other properties and use a select query inside job to retrieve these values and assign it to variable to be passed to DTexec utility------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
pass parameter to job