Passing variables dynamically during SSIS runtime

• PFlorenzano-641896

  SSCommitted

  Points: 1643

  More actions

  February 4, 2013 at 9:25 am

  #288795

  Hello,

  We have an SSIS release package that refreshes several database environments at once. Before the refresh begins, we need to 'hard code' variables within the package, save it, than execute the package manually.

  With that being said, is there a way we can pass these variables dynamically using a configuration file during run time, or some other method?

  Thank you for your answers.

• Chrissy321

  SSCoach

  Points: 15769

  More actions

  February 4, 2013 at 11:51 am

  #1584074

  You can use configuration files or dtexec and the set parameter.

  http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/66500/

  http://msdn.microsoft.com/en-us/library/ms162810(v=SQL.105).aspx

• PFlorenzano-641896

  SSCommitted

  Points: 1643

  More actions

  February 4, 2013 at 12:21 pm

  #1584084

  Thank you Chrissy!

  I will give the configuration file a try.

  Another way that I found was to use the 'Set Values' table within the SQL Server Agent job.

• Chrissy321

  SSCoach

  Points: 15769

  More actions

  February 4, 2013 at 1:08 pm

  #1584095

  http://www.sqlservercentral.com/blogs/dknight/2011/03/14/passing-values-into-an-ssis-package-at-runtime-from-outside-the-package/

  Here is a nice overview.