title: How do I prompt for input from an SSIS package?
body: <p>I want to be able to have a sql query in my DTSX package and I want to be able to have some sort of prompt to update the value of a null column. See what I have below:    </p>
  
  <pre><code>UPDATE  SF1411
  SET     [QuoteNumber]   = '123456'
      ,   [ItemNumber]    = '123654-100'
      ,   [DeleteItem]    = 'NO'
  WHERE   [QuoteNumber]   = '0'
  </code></pre>
  
  <p>I want to be able to be prompted for the QuoteNumber and ItemNumber, then have the script update as needed. Is this possible and if so how can I do it? </p>