March 22, 2010 at 1:41 am
I have an SSIS job with a date variable - Rundate.
In power builder I have a text box which holds the Rundate.
Now I want to call SSIS job from powerbuilder and pass the Rundate as value to SSIS RunDate variable.
Could you please help me how can I do this?
March 22, 2010 at 6:57 am
I don't know how you call the SSIS job exactly, but you can pass parameters with the SET command.
You can find more information at the following URL:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 23, 2010 at 11:29 am
How do you intend to invoke (start) the SSIS package, SQL Agent Job, object model, command line?
CEWII
March 24, 2010 at 12:49 am
I want to invoke SQL Agent job.
March 24, 2010 at 11:42 am
Then you have a bit of a problem. The job does not accept parameters. This leaves a couple different paths. You can use table based package configurations or you can have the package get the data from somewhere. Although it is possible to use files such as file based package configurations I don't view this as a very good option.
CEWII
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply