March 3, 2011 at 4:11 am
Hi
I have a problem in executing a package through job.
The scenario is I have a Data flow task in which data source is a Stored procedure having two input parameters of type(datetime,int)
I have mapped these parameter to package variables.
I have to run this package through job. Parameters to be passed are Current date for datetime variable and 1 for int variable for a job running at a 8:00 AM daily and 2 for a job running at 10:00 AM daily.
How do I pass values for the variables in this case.
March 3, 2011 at 4:54 am
Regarding the datetime variable:
you can use an expression on the variable to set it's value.
Set the property EvaluateAsExpression of the variable to true.
Then create an expression for the variable, where you use the GETDATE() function.
For the other variable, you can use the Set Values tab in the SQL Server Integration Services jobstep.
In the property path, you put the following:
\Package.Variables[User::myVariable].Properties[Value]
In the Value field, you put 1 or 2, according to which job you are configuring.
If you have more questions, just ask.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply