SSIS Paramater on start

Larry Brister
Larry Brister used Ask the Experts™
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?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server Consultant
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.
Larry Bristersr. Developer



Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial