How to set Environment variable for SSIS package

• sqlstud

  SSCrazy

  Points: 2527

  More actions

  June 17, 2012 at 11:47 pm

  #263020

  Hi,

  I need to set the environment variables for SSIS package.

  The thing is that we need to use Command Prompt to set the environment variable(Not My computer -> Advanced).

  Could you please let me know how to do it?

  Regards

  SqlStud

• inampudianil

  Ten Centuries

  Points: 1274

  More actions

  June 18, 2012 at 1:17 am

  #1502101

  Hi,

  The Environemnt varibales that you are trying to Create(or) making any Changes made with SET will remain only for the duration of the current CMD session only...

  try Checking this link

  http://ss64.com/nt/set.html

  Best Reagrds

  Anil Inampudi

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  June 18, 2012 at 2:04 am

  #1502110

  Maybe this article will help.

  ---