How to Use package variable in Execute SQL task

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  November 2, 2010 at 8:21 am

  #157296

  hi All,

  I want to use the variable in Execute sql task.

  My script will return based on the Variable.

  DECLARE @Env VARCHAR(5)

  DECLARE @FilePath VARCHAR(500),@ToMail VARCHAR(500)

  SET @Env=SSISVAriable

  SELECT @FilePath=CASE @EnvWHEN 'Dev' THEN '\\Dev\'

  WHEN 'Test' THEN '\\Test\'

  WHEN 'UAT' THEN '\\UAT\'

  WHEN 'PrdSRV' THEN '\\PrdSRV\'

  ELSE '\\share\' END,

  @ToMail=CASE @EnvWHEN 'Dev' THEN 'abcd@xyz.com'

  WHEN 'Test' THEN 'abcd@xyz.com'

  WHEN 'UAT' THEN 'abcd@xyz.com'

  WHEN 'PrdSrv' THEN 'a2z@xyz.com;1to9@abc.com'

  ELSE 'saasd@gmail.com' END

  Exec proc_test @FilePath,@tomail

  Please give steps or any link which will helpful.

  Thanks,

  Sasidhar Pulivarthi

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  November 2, 2010 at 8:34 am

  #1245431

  To use SSIS variables within the Execute SQL task, use an Expression to set the appropriate property of the task.

  ---

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  November 2, 2010 at 10:47 am

  #1245541

  http://blogs.techrepublic.com.com/datacenter/?p=237

  This link solved my problem

  😀