I intend to write up a few of the important things that ive found and that are not necessarily clear in any official Microsoft atricles or KBs.
I'll start off with one of the things that took me the longest to find - If you have an SSIS package, that contains a Web Service Task that expects parameters, how do you pass parameters to it in SSMS?
SQL Server Agent
Setting the Parameters/Variables to pass to the Web Service
In the Set Values tab in the Job Step Properties of the package, you can set the value of the package variables, which will be used to be passed as the parameters into the Web Service. In property path, add :
\Package.Variables[VarName].Value (Where VarName is the name of the variable defined in BIDS - In this case the variable I want to pass is UserID) into the Property Path column and and value you want to pass in the Value column
No comments:
Post a Comment