August 22, 2009 at 3:42 pm
How to create a package with 2 configuration files and schedule a job to make use of either one of the configuration file? If we run the package from command prompt, could make the package use either of the configuration files. If we are using a SQL Server Agent or a Job Scheduler how do we achieve the same?
Regards
August 22, 2009 at 9:37 pm
Assuming that you have setup your configuration file in your package to be an indirect configuration (i.e., controlled through an environment parameter), then create a SQL Agent job step for an SSIS package execution, point it to your package and use either the command line options or the command file option to reset the environment variables to your specific configuration file.
See here for more info: http://msdn.microsoft.com/en-us/library/ms139805(SQL.90).aspx
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply