how to use server name dynamically for SSIS - Execute SQL Task

• nithiyanandam-447806

  Ten Centuries

  Points: 1197

  More actions

  March 5, 2012 at 2:24 am

  #256910

  Hi,

  In my ssis package, I am using two servers for stage tables and destination tables.

  After insert the data from stage server to destination server, I need to update the processed records staus to the stage tables.

  It works fine when server names are hardcoded. But my prod environment, they asked to assign the server name to variables and use dynamically through the entire package.

  I have no idea. can any one help on this.

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  March 5, 2012 at 5:09 am

  #1454731

  You can find an example here:

  http://consultingblogs.emc.com/jamiethomson/archive/2005/12/09/2480.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP