SSIS Paramater on start
I have an SSIS that runs fine but we would like to make it generic and pass in a OriginID from a windows task scheduler
So how do I set up that parameter in SSIS
And what is the command to start it in Windows Scheduler?
So how do I set up that parameter in SSIS
And what is the command to start it in Windows Scheduler?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
dtexec is a command line utility for running SSIS projects and packages.
What version of SSIS are you using? With 2012 and beyond you can define parameters and pass their values in from dtexec if you use the package deployment model. (Deploy Integration Services (SSIS) Projects and Packages).
With older versions, or with the package deployment model you would, as I recall, have to define a variable to serve as the parameter and then set the value from dtexec using the /SET parameter.
What version of SSIS are you using? With 2012 and beyond you can define parameters and pass their values in from dtexec if you use the package deployment model. (Deploy Integration Services (SSIS) Projects and Packages).
With older versions, or with the package deployment model you would, as I recall, have to define a variable to serve as the parameter and then set the value from dtexec using the /SET parameter.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial