title: How to pass variable as a parameter in Execute SQL Task SSIS?
body: <p>I have ssis package in that I'm taking values from flat file and insert it into table.</p>
  
  <p>I have taken one Execute SQL Task in that creating one temptable </p>
  
  <pre><code>CREATE TABLE [tempdb].dbo.##temptable 
  (
  date datetime,
  companyname nvarchar(50),
  price decimal(10,0),
  PortfolioId int,
  stype nvarchar(50)
  )
  
  Insert into [tempdb].dbo.##temptable (date,companyname,price,PortfolioId,stype) 
  SELECT   date,companyname,price,PortfolioId,stype
  FROM        ProgressNAV
  WHERE     (Date = '2011-09-30') AND (PortfolioId = 5) AND (stype in ('Index'))
  ORDER BY CompanyName
  </code></pre>
  
  <p>Now in above query I need to pass <code>(Date = '2011-09-30') AND (PortfolioId = 5) AND (stype in ('Index'))</code>
  these 3 parameter using variable name I have created variables in package so that I become dynamic.</p>