Passing values to Variables during runtime from a table in a SQL database in SSIS

• Prasune Verma

  SSC-Addicted

  Points: 453

  More actions

  May 20, 2015 at 3:08 pm

  #318443

  Hi,

  I have been working on the design of an SSIS package in BIDS 2010.

  I have some variables defined in my package which are currently being feb by hard coded values which I have already provided during the definition of the variables.

  However, what I need to do is to fetch values to those variables from a table in an external datbase.

  How to get that done? Please let me know the way or any link explaining the steps would be handy.

  Thanks in advance.

  Prasune.

• PB_BI

  SSCoach

  Points: 17463

  More actions

  May 21, 2015 at 2:57 am

  #1799573

  This will get you started:

  https://dwbi1.wordpress.com/2011/06/06/ssis-updating-a-variable-based-on-database/

  ---

  I'm on LinkedIn

• Prasune Verma

  SSC-Addicted

  Points: 453

  More actions

  May 21, 2015 at 7:54 am

  #1799678

  Thank You. That should help.

  I will try that way and will let you know if I encounter any challenges ahead.

  Thanks,

  Prasune